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

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
Get step-by-step solutions from verified subject matter experts
