Please use USE EXCEL AND show how answers were derived (formulas) for ALL three of the following problems!! In advance, thank you for your prompt attention.

1. Quincy Smith Enterprises expects the following unit sales over the next five months: Irwin's goal is to maintain an inventory equal to 20% of next month's sales requirements. March 31st inventory is projected to be 70,000 units. Required: 40 points Prepare a Production Budget (in units) for Irwin for April, May, June, and July.

MONTH	UNIT SALES
April	400,000
May	480,000
June	540,000
July	600,000
August	560,000

Irwin's goal is to maintain an inventory equal to 20% of next month's sales requirements. March 31^stinventory is projected to be 70,000 units.

Prepare a Production Budget (in units) for Irwin for April, May, June, and July.

2. Kindschuh Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.07 direct labor-hours. The direct labor rate is $8.50 per direct labor-hour. The production budget calls for producing 4,800 units in June and 5,300 units in July. Construct the direct labor budget for the next two months, June and July

3. Keenan Williams, Inc., Inc., is preparing its budget for the second quarter of the calendar year. The following sales data (in units) have been forecasted:

April	30,000
May	32, 000
June	36,000
July	40,000
August	50,000

Additional information: Desired ending inventory each month--Finished goods: 30% of next month's sales Desired ending inventory each month--Raw materials: 25% of next month's production needs Number of raw material units required per finished unit: 4; Each units of materials costs $25

a. Prepare a Production Budget for the 2^nd Quarter

b. Prepare a Materials Budget for the 2^ndQuarter, in units and dollars

In advance, thank you for your prompt attention to this important matter!