Master Budget Project Excel Project Complete problem #1 of Exercise 6-24, for Quarter 1 only. Instructions: For the value in any cell that is dependent upon another number in the data, you must have a formula in the cell such that if sales volume changes, everything changes automatically. Submit 2 versions of the master budget, one version showing the formulas, and the second version showing the calculated numbers. Submit an electronic soft copy version to Blackboard. 6-24 Budgets for production and direct manufacturing labor. (CMA, adapted) Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletter's master budget and has accumulated the following information for 2015: April May 8,000 2015 February March 14,000 7,000 $50.50 $50.50 2.0 1.5 $12.00 $12.00 Estimated sales in units Selling price Direct manufacturing labor-hours per unit Wage per direct manufacturing labor-hour 8,000 January 10,000 $54.00 2.0 $12.00 $50.50 $50.50 1.5 1.5 $13.00 $13.00 In addition to wages, direct manufacturing labor-related costs include pension contributions of $0.50 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, 2015, the Social Security tax rates are 7.5% for employers and 7.5% for employees. The cost of employee benefits paid by Roletter on its employees is treated as a direct manufacturing labor cost. Roletter has a labor contract that calls for a wage increase to $13 per hour on April 1, 2015. New labor- saving machinery has been installed and will be fully operational by March 1, 2015. Roletter expects to have 17,500 frames on hand at December 31, 2014, 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. 1. Prepare a production budget and a direct manufacturing labor budget for Roletter Company by month and for the first quarter of 2015. You may combine both budgets in one schedule. The direct manufac- turing labor budget should include labor-hours and show the details for each labor cost category. 2. What actions has the budget process prompted Roletter's management to take? 3. How might Roletter's managers use the budget developed in requirement 1 to better manage the company? Required Master Budget Project Excel Project Complete problem #1 of Exercise 6-24, for Quarter 1 only. Instructions: For the value in any cell that is dependent upon another number in the data, you must have a formula in the cell such that if sales volume changes, everything changes automatically. Submit 2 versions of the master budget, one version showing the formulas, and the second version showing the calculated numbers. Submit an electronic soft copy version to Blackboard. 6-24 Budgets for production and direct manufacturing labor. (CMA, adapted) Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletter's master budget and has accumulated the following information for 2015: April May 8,000 2015 February March 14,000 7,000 $50.50 $50.50 2.0 1.5 $12.00 $12.00 Estimated sales in units Selling price Direct manufacturing labor-hours per unit Wage per direct manufacturing labor-hour 8,000 January 10,000 $54.00 2.0 $12.00 $50.50 $50.50 1.5 1.5 $13.00 $13.00 In addition to wages, direct manufacturing labor-related costs include pension contributions of $0.50 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, 2015, the Social Security tax rates are 7.5% for employers and 7.5% for employees. The cost of employee benefits paid by Roletter on its employees is treated as a direct manufacturing labor cost. Roletter has a labor contract that calls for a wage increase to $13 per hour on April 1, 2015. New labor- saving machinery has been installed and will be fully operational by March 1, 2015. Roletter expects to have 17,500 frames on hand at December 31, 2014, 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. 1. Prepare a production budget and a direct manufacturing labor budget for Roletter Company by month and for the first quarter of 2015. You may combine both budgets in one schedule. The direct manufac- turing labor budget should include labor-hours and show the details for each labor cost category. 2. What actions has the budget process prompted Roletter's management to take? 3. How might Roletter's managers use the budget developed in requirement 1 to better manage the company? Required