ent 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 inventory 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 document showing the names of the result and the results required in one to six below showing also the cell address where the result can be found.
5. Explain the layout of the spreadsheet so that Capricornia Inc’s staff would be able to read and then use the spreadsheet.
6. Explain how you have secured the spreadsheet so that it can not easily be altered by Capricornia Inc’s staff.
In performing the above, you are to:
i. Calculate the predetermined overhead rate based on direct labour cost.
ii. Calculate the ending balance of each Job as of April 30.
iii. Calculate the ending balance of Work in Progress as of 30 April.
iv. Calculate the cost of goods sold for April.
v. Assume Capricornia Inc prices its jobs at cost plus 30%. Calculate the price of the one job that was sold during April. (Round to the nearest dollar)
vi. You are also sepa
本论文由英语论文网提供整理,提供论文代写,英语论文代写,代写论文,代写英语论文,代写留学生论文,代写英文论文,留学生论文代写相关核心关键词搜索。