Question: Please design spreadsheet on Excel TASK 3 - Determine costs using Activity Based Costing System Honeybee Technology manufactures a line of mobile phones and management

Please design spreadsheet on Excel

Please design spreadsheet on Excel TASK 3 - Determine costs using Activity

TASK 3 - Determine costs using Activity Based Costing System Honeybee Technology manufactures a line of mobile phones and management has identified the following overhead costs and related cost drivers for the coming year: Overhead item Expected Cost Cost Driver Quantity Setup costs $24,000 Number of setups 60 Ordering costs $9,000 Number of orders 900 Machine costs $36,000 |Machine hours 36,000 Power $5,000 Kilowatt hours 100,000 Blue Pink Direct Materials $1,300 $1,525 Direct Labour $900 $900 Units completed 500 500 Number of setups 6 10 Number of orders 60 120 Machine hours 1,500 2,000 Kilowatt hours 6,000 5,000 Required: 1. Design a spreadsheet to determine the cost of each product using an activity-based costing system. Your worksheet should include a data section and clearly show the total costs for each product

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!