PLEASE HELP! No handwritting, please use Spreadsheets. Complete part A and B please!

Will give you 4 thumbs up when answered in entirety and correctly.

PART A:

PART B:

Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,600 units; October, 4,500 units; November, 6,700 units; and December, 8,200 units. The company's policy is to maintain finished goods inventory equal to 60% of the next month's sales. At the end of August, the company had 1,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September October Next month's budgeted sales (units) % November % % 0 Units to be produced 0 0 0 Ornamental Sculptures Mfg. manufactures garden sculptures. Each sculpture requires 7 pounds of direct materials at a cost of $3 per pound and 0.4 direct labor hours at a rate of $19 per hour. Variable manufacturing overhead is charged at a rate of $3 per direct labor hour. Fixed manufacturing overhead is $3,400 per month. The company's policy is to maintain direct materials inventory equal to 30% of the next month's materials requirement. At the end of February the company had 4,980 pounds of direct materials in inventory. The company's production budget reports the following. Production Budget Units to be produced March 3,700 April 5,000 May 5,600 (1) Prepare direct materials budgets for March and April. (2) Prepare direct labor budgets for March and April. (3) Prepare factory overhead budgets for March and April. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare direct materials budgets for March and April. April ORNAMENTAL SCULPTURES MFG. Direct Materials Budget For the Months of March and April March Budgeted production (units) Materials requirements per unit (lbs.) Materials needed for production (lbs.) Budgeted ending inventory (lbs.) Total materials requirements (lbs.) Budgeted beginning inventory (lbs.) Materials to be purchased (lbs.) Direct material cost per Ib. Total budgeted direct materials 0 0 0 $ 0 Required 1 Required 2 Required 3 Prepare direct labor budgets for March and April. (Round "DL hours required per unit" answers to two decimal places.) ORNAMENTAL SCULPTURES MFG. Direct Labor Budget For the Months of March and April March April Budgeted production (units) DL hours required per unit Total direct labor hours needed Direct labor rate per hour Total budgeted direct labor $ 0 $ 0 0 0 Required 1 Required 2 Required 3 Prepare factory overhead budgets for March and April. ORNAMENTAL SCULPTURES MFG. Factory Overhead Budget For the Months of March and April March April Total direct labor hours needed VOH rate per DL hour Budgeted variable overhead $ 0 $ Budgeted fixed overhead Total budgeted factory overhead $ $ 0 0 0