Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Non-Specialists

Authors: Eddie McLaney, Peter Atrill

11th Edition

1292244011, 9781292244013

More Books

Students also viewed these Accounting questions