ivities. About 40 percent of their time is spent processing transactions, with the rest of their time split evenly between issuing statements and answering questions. Phone time for all seven workers is used only for answering clients' questions. Computer time is 70 percent transaction processing, 20 percent statement preparation, and 10 percent question answering. Furthermore, my own time and that of my computer and telephone are 100 percent administration. Credit card transactions represent about 20 percent of the total automatic teller transactions.
Required
Prepare an activity table using five columns: activity name, activity description, activity type (primary or secondary), cost object(s), and activity driver.
Part B
Refer to the details above. The general ledger reveals the following annual costs:
Supervisor’s salary 64,600
Clerical salaries 210,000
Computers, desks and printers 32,000
Computer supplies 7,200
Telephone expenses 4,000
ATM 1,250,000
All non-labour resources, other than the ATM, are spread evenly among the eight credit department employees (in terms of assignment and usage). Credit department employees have no contact with ATMs. Printers and desks are used in the same ratio as computers by the various activities.
Required
1. Assign and determine the cost of primary and secondary activities.
Question 2
Capricornia Inc
There are two parts to this question.
Part A
On April 1, Capricornia Inc had the following balances in its in无忧论文 【http://www.uklunwen.com】ventory accounts:
Materials Inventory $16,3650
Work-in-Process Inventory 21,352
Finished Goods Inventory 15,200
Work – in-process inventory is made up of three jobs with the following costs:
Job 30 Job 31 Job 32
Direct material $2,650 $1,900 $3,650
Direct labour 1,900 1,340 4,000
Applied overhead 1,520 1,072 3,200
During April, Capricornia Inc experienced the following transactions:
1. Purchases materials on account for $21,000.
2. Requisitioned materials: Job 30, $12,500; Job 31, $11,200; job 32, $5,500.
3. Collected and summarised job tickets: Job 30, 250 hours @$12 per hour; Job 31, 275 hours @$15 per hour; Job 32, 140 hours @ @20 per hour.
4. Applied overhead on the basis of direct labour cost.
5. Actual overhead was $8,178.
6. Completed and transferred Job 31 to the finished goods warehouse.
7. Shipped Job 31 and billed the customer for 130 percent of the cost.
Required
1. You are to prepare all calculations in a spreadsheet. The design of the spreadsheet should be such that once you, as consultant, have passed the spreadsheet on to Capricornia Inc’s staff, they are unable to amend any description item or amount calculated.
2. You are to print a report from the spreadsheet that shows rows and columns together with the formula that has been used in each cell of the spreadsheet.
3. You are to print the results of the spreadsheet showing the value of all cells involved in the calculations.
4. You are to also print a page in a word documen |
|
支付方式咨询：357500023@qq.com