Company and artistic frames for des ot wedding austions, and other special events. Hon kom, the come a responsible for preparing Austin's master budget and has come the following domason for 2018 the montoww maths francia Wormation) Ce konto view storal information) Requirement. Prepare a production budget and direct mansuring or con bufget for Asti Comarny by month and for safetter of 2018. You may combine bon budgets in one schedule. The direct mariacturing labor cost should not bor hours and show the details for each labor costaty Blut we by presering tech budget and coating the total hours of direct manufacturing ceded for the three months in the quantena es for the Fath by preparing the beton portion of the show for the decanufacturing or by on the career the direct marutturing labor hours per un to che dicima XX. Do not found trim calculations and then one of our the budget de manger hours per unit to the whole number Austin Company Budget for Production and Direct Manufacturing Labor For the Quarter Ended March 31, 2018 January Formy Marc Adidat nog steedood very) Detector User Det bor hours Elence in the sand then click Check Awe 5 Char AB Data Table - a 2018 et 1 April Estimated sales in units 9,000 January February March 17,000 19,000 5,000 $ 53.00 $ 52.00 $ 52.00 $ 2.5 2.5 2.0 May 9,000 52.00 Selling price Direct manufacturing labor-hours per unit Wage per direct manufacturing labor-hour 52.00 $ 2.0 2.0 14.00 $ $ 12.00 $ 12.00 $ 12.00 $ 14.00 Print Done ng m In addition to wages, direct manufacturing labor-related costs include pension contributions of $0.60 per hour, worker's compensation insurance of $0.10 per hour, employee medical insurance of $0.40 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 Austin on its direct manufacturing employees is treated as a direct manufacturing labor cost. in 8 Austin has a labor contract that calls for a wage increase to $14 per hour on April 1, 2018. New labor-saving machinery has been installed and will be fully operational by March 1, 2018. Austin expects to have 21,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. Print Done A Requirements 1. Prepare a production budget and a direct manufacturing labor cost budget for Austin 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. 2. What actions has the budget process prompted Austin's management to take? 3. How might Austin's managers use the budget developed in requirement 1 to better manage the company? Print Done