Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am struggling with understanding how to correctly solve this problem. If you could give general direction with the answer that would be amazing. Thank

I am struggling with understanding how to correctly solve this problem. If you could give general direction with the answer that would be amazing.

Thank you!

Homework:Module 2 Exercises

DeWitt

Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Ron Jangles,

the controller, is responsible for preparing DeWitt's master budget and has accumulated the following information for

2018:

.Requirement 1. Prepare a production budget and a direct manufacturing labor cost budget for DeWitt Company by month and for the first quarter of 2018.

You may combine both budgets in one schedule. The direct manufacturing labor cost budget should include labor-hours and show the details for each labor cost category.

Start the schedule by preparing the production budget and calculating the total hours of direct manufacturing labor time needed for the three months in the quarter, then calculate the values for the quarter. Finish by preparing the bottom portion of the schedule for the direct manufacturing labor by month, then quarter. (Enter the direct manufacturing labor-hours per unit to one decimal place, X.X. Do not round interim calculations, and then enter all amounts in the budget [other than the direct manufacturing labor-hours per unit] to the nearest whole number.)

DeWitt Company

Budget for Production and Direct Manufacturing Labor

For the Quarter Ended March 31, 2018

January

February

March

Budgeted sales (units)

Add target ending finished goods inventory (units)

Total requirements (units)

Deduct beginning finished goods inventory (units)

Units to be produced

Direct manufacturing labor-hours per unit

Total hours of direct manufacturing labor time needed

Data Table

2018

January

February

March

April

May

Estimated sales in units

10,000

11,000

7,000

9,000

9,000

Selling price

$54.00

$51.50

$51.50

$51.50

$51.50

Direct manufacturing labor-hours per unit

2.0

2.0

1.5

1.5

1.5

Wage per direct manufacturing labor-hour

$12.00

$12.00

$12.00

$13.00

$13.00

More Info

In addition to wages, direct manufacturing labor-related costs include pension contributions of $0.40 per hour, worker's compensation insurance of $0.20 per hour, employee medical insurance of$0.30 per hour, and Social Security taxes. Assume that as of January 1,2018, the Social Security tax rates are 7.5% for employers and 7.5% for employees. The cost of employee benefits paid by DeWitt on its direct manufacturing employees is treated as a direct manufacturing labor cost.

DeWitt has a labor contract that calls for a wage increase to $13 per hour on April 1, 2018. New labor-saving machinery has been installed and will be fully operational by March 1,2018 DeWitt expects to have 14,500 frames on hand at December 31, 2017, and it has a policy of carrying an end-of-month inventory of 100% of the following month's sales plus 50% of the second following month's sales

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

Entrepreneurship Successfully Launching New Ventures

Authors: Bruce R. Barringer, R. Duane Ireland

4th Edition

0132555522, 978-0132555524

More Books

Students also viewed these Accounting questions

Question

Who will implement and maintain the project after launch?

Answered: 1 week ago

Question

analyze aesthetic enhancing design rules.

Answered: 1 week ago

Question

apply communication design concepts into creative projects.

Answered: 1 week ago