PLEASE CAN YOU DO IN EXCEL STEP BY STEP

THANK YOU

:)

1. (# 6.6) Use the following sales forecast March 3,250 April 7,250 May 11,500 June 9,500 Total 31,500 (a) Assume the production manager decides to produce and even amount each month (i.e. 31500=7,875 per month). What is the inventory schedule? (b) Assume that inventory costs $12 per unit to acquire and monthly rate is 1%. What is the monthly financing cost for the four months? 2. (#6.20) A firm has 15 percent of its sales paid for in cash and 85 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January $65,000 February 55,000 March 100,000 April 45,000 Sales in December of the prior year were $75,000. Prepare a cash receipts schedule for January through April. Prepare a cash receipts schedule for January through April