Hello aali78614, Thank you so much for your past help. It has bees a pleasure. I need help with this one. It needs to be formatted into excell with all formulas in place and which will allow me to finish it with the fewest input of data. Please respond and help me if you can.

Bombs Away Video Games Corporation has forecasted the following monthly sales: January February March April May June $ 119,000 July 112,000 August 44,000 September 44,000 October 39,000 November 54,000 December Total annual sales = $984,000 $ 64,000 64,000 74,000 104,000 124,000 142,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per un production policy is followed. Each month's production is equal to annual sales (in units) divided by 12. Of each month's sales, 40 percent are for cash and 60 percent are on account. All accounts receivable are collected sale is made. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 44,000 units. Bombs Away Video Games Corporation Production and inventory schedule in units Beginning inventory January February March April May June July August September October November December + 44,000 Production - Sales = E in b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. January Sales February Bombs Away Video Gam Cash Receipts S March $ $ $ $ $ $ $ $ $ Cash receipts: Cash sales Prior month's credit sales Total cash receipts July Sales August Bombs Away Video Gam Cash Receipts Sc Septembe $ $ $ $ $ $ $ $ $ Cash receipts: Cash sales Prior month's credit sales Total cash receipts c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for which they occur. Other cash payments, besides those for production costs, are $64,000 per month. January February Bombs Away Video Games Corp Cash Payments Schedule Constant production March Production cost $ $ $ $ $ $ Other cash payments Total cash payments July Production cost August Bombs Away Video Games Corp Cash Payments Schedule Constant production September $ $ $ $ $ $ Other cash payments Total cash payments d. Prepare a monthly cash budget for January through December using the cash receipts schedule from part b and th schedule from part c. The beginning cash balance is $5,000, which is also the minimum desired. (Leave no cells b enter "0" wherever required. Negative amounts should be indicated by a minus sign.) January Beginning cash February Bombs Away Video Ga Cash Bud Marc $ $ $ $ $ $ Ending cash balance $ $ $ Cumulative loan balance $ $ $ Net cash flow Cumulative cash balance Monthly loan or (repayment) July Beginning cash August Bombs Away Video G Cash B Se $ $ $ $ $ $ Ending cash balance $ $ $ Cumulative loan balance $ $ $ Net cash flow Cumulative cash balance Monthly loan or (repayment) Bombs Away Video Games Corporation has forecasted the following monthly sales: January February March April May June $ 119,000 July 112,000 August 44,000 September 44,000 October 39,000 November 54,000 December Total annual sales = $984,000 $ 64,000 64,000 74,000 104,000 124,000 142,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per un production policy is followed. Each month's production is equal to annual sales (in units) divided by 12. Of each month's sales, 40 percent are for cash and 60 percent are on account. All accounts receivable are collected sale is made. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 44,000 units. Bombs Away Video Games Corporation Production and inventory schedule in units Beginning inventory January February March April May June July August September October November December + 44,000 Production - Sales = E in b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. January Sales February Bombs Away Video Gam Cash Receipts S March $ $ $ $ $ $ $ $ $ Cash receipts: Cash sales Prior month's credit sales Total cash receipts July Sales August Bombs Away Video Gam Cash Receipts Sc Septembe $ $ $ $ $ $ $ $ $ Cash receipts: Cash sales Prior month's credit sales Total cash receipts c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for which they occur. Other cash payments, besides those for production costs, are $64,000 per month. January February Bombs Away Video Games Corp Cash Payments Schedule Constant production March Production cost $ $ $ $ $ $ Other cash payments Total cash payments July Production cost August Bombs Away Video Games Corp Cash Payments Schedule Constant production September $ $ $ $ $ $ Other cash payments Total cash payments d. Prepare a monthly cash budget for January through December using the cash receipts schedule from part b and th schedule from part c. The beginning cash balance is $5,000, which is also the minimum desired. (Leave no cells b enter "0" wherever required. Negative amounts should be indicated by a minus sign.) January Beginning cash February Bombs Away Video Ga Cash Bud Marc $ $ $ $ $ $ Ending cash balance $ $ $ Cumulative loan balance $ $ $ Net cash flow Cumulative cash balance Monthly loan or (repayment) July Beginning cash August Bombs Away Video G Cash B Se $ $ $ $ $ $ Ending cash balance $ $ $ Cumulative loan balance $ $ $ Net cash flow Cumulative cash balance Monthly loan or (repayment)