Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help show me how to answer on excel file Project 2: Flexible Budget and Budget Report (10 points) Upload your file to Moodle

image text in transcribed
can you help show me how to answer on excel file
Project 2: Flexible Budget and Budget Report (10 points) Upload your file to Moodle by the deadline specified. Do NOT coil your fiel Halloween Supplies, Inc. estimates that 120.000 direct labor hours will be worked during 2021 in the Packaging Department. Based on this estimate the following budget was developed for annual manufacturing overhead costs. Variable Overhead Costs Fixed Overhead Costs $48.000 Supervision $78.000 28.800 Depreciation 26,400 Repairs 26,400 Insurance 15,600 Utilities 17.400 Rent 10 200 Lubricants 6,600 Property taxes 7.200 $127,200 $137 400 Indirect labor Indirect materials It is estimated that direct labor hours worked each month will range from 8,000 to 12,000 hours. During January, 10,000 direct labor hours were worked and the following overhead costs were incurred. Variable Overhead Costs Indirect labor $4,300 Indirect materials 2,500 Repairs 2,350 Utilities 1,600 Lubricants 600 $11,350 Fixed Overhead Costs Supervision $6,500 Depreciation 2,200 Insurance 1,300 Rent 850 Property taxes 600 $11,450 Instructions for Project 2: 1. Using Excel, prepare a monthly flexible manufacturing overhead budget for each increment of 1,000 direct labor hours over the relevant range for the year ending December 31, 2021. Refer to Illustration 23-13 in the chapter for an example. 2. Using Excel, prepare a manufacturing overhead budget report for January in good form. Refer to Illustration 23-16 in the chapter as a guide

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

Wiley Federal Government Auditing Laws Regulations Standards And Practices

Authors: Edward F. Kearney, Roldan Fernandez, Jeffrey W. Green, David M. Zavada

2nd Edition

1118555856, 978-1118555859

More Books

Students also viewed these Accounting questions

Question

List the seven reasons projects fail.

Answered: 1 week ago