please help with part d. the spaces that are marked incorrect. everything else is correct

Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 103,000 July $ 48,000 February 96,000 August 48,000 March 28,000 September 58,000 April 28,000 October 88,000 May 23,000 November 100,000 June 38,000 December 126,000 Total annual sales - $792,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per unit to produce. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by 12. of each month's sales, 30 percent are for cash and 70 percent ore on account. All accounts receivable are collected in the month after the sale is made a. Construct a monthly production and Inventory schedule in units. Beginning Inventory in January is 28,000 units. January February March April May June Bombs Away Video Games Corporation Production and Inventory Schedule in Units Beginning Production Sales Inventory 28,000 14200 20,600 20,600 13,200 19,200 14,500 13,200 5,600 22,200 13.200 5,600 29,800 13,200 4,000 38,400 13.200 7,600 Ending Inventory 20,600 14,600 22,200 29,800 38,400 44,000 UE SOIE is lllaue. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 28,000 units. January February March April May June July August September October November December Bombs Away Video Games Corporation Production and Inventory Schedule in Units Beginning Production Sales Inventory 28,000 13,200 20,600 20,600 13,200 19,200 14,600 13,200 5,600 22,200 13,200 5,600 29,800 13,200 4,600 38,400 13,200 7,600 44,000 13,200 9,600 47,600 13,200 9,600 51,200 13,200 11,600 52,800 13,200 17,600 48,400 13,200 21,600 40,000 13,200 25,200 Ending Inventory 20,600 14.600 22,200 29,800 38,400 44,000 47,600 51,200 52,800 48,400 40,000 28,000 b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. Bombs Away Video Games Corporation b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. Bombs Away Video Games Corporation Cash Receipts Schedule January February March 103,000 $ 96,000 $ 28,000 $ April 28,000 May 23,000 $ June 38,000 $ $ Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts $ 6,900 $ 30,900 $ 70,000 100,900 $ 28,800 $ 72,100 100,900 $ 8,400 $ 67,200 75,600 $ 8,400 $ 19,600 28,000 $ 19,600 26,500 $ 11,400 16,100 27,500 $ Bombs Away Video Games Corporation Cash Receipts Schedule July August September 48,000 $ 48,000 $ 58,000 $ October November December 88,000 $ 108,000 $ 126,000 $ Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts $ 14.400 $ 26,600 41,000 $ 14,400 $ 33,600 48,000 $ 17,400 $ 33,600 51,000 $ 26,400 5 40,600 67.000 $ 32,400 $ 61,600 94,000 $ 37,800 75,600 113,400 $ c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for in the month in which they occur. Other cash payments, besides those for production costs, are $48,000 per month. June Bombs Away Video Games Corporation Cash Payments Schedule January February March 26,400 $ 26,400 $ 26,400 S 48.000 48,000 48,000 74,400 $ 74,400 $ 74,400 S $ Production cost Other cash payments Total cash payments April 26,400 $ 48,000 74,400 $ May 26.400 $ 48,000 74,400 $ 26,400 48,000 74.400 $ Bombs Away Video Games Corporation Cash Payments Schedule July August September October November December 26,400 $ 26,400 5 26,400 $ 26,400 $ 26,400 $ 26,400 48,000 48,000 48,000 48,000 48,000 74 ao s 74,400 $ 74,400 $ 74,400 $ 74,400 $ 74.400 $ Production cost Other cash payments Total cash payments 48,000 $ June $ Beginning cash Net cash flow Cumulative cash balance Monthly loan or (repayment) Ending cash balance Cumulative loan balance Cash Budget January February March 5,000$ 31,500$ 58,000 $ 26.500 26,500 1,200 31,500 $ 58,000$ 59,200 $ OS 0$ 0$ 31.500$ 58,000 $ 50,200 $ OS 0 $ $ April 59.2005 (46,400) 12,800 $ 0 12,800 0 $ May 5,000 $ (47,900) (42,900) $ 47.900 5,000 $ 47,900 S $ $ IS $ 5,000 (46.900) (41.900) 46,900 5,000 94.800 Answer is complete but not entirely correct. Bombs Away Video Games Corporation Cash Budget July August September October November December 5,000$ 5,000$ 5.000 $ 5.000 5,000$ 5.000 (33,400) (26,400) (23.400) (7.400) 19,600 39.000 (28.400) (21.400) (18.400) (2.400) $ 24,600 $ 44,000 33.400 26,400 23.400 7400 (19.600) (39.000) 5.000S 5,000$ 5.000 IS 5,000 5,000 $ 5,000 128.2003 154.600 $ 178,000 $ 185,4003 165.800 $ 126 800 Beginning cash Not cash flow Cumulative cash balance Monthly loan or repayment) Ending cash balance Cumulative loan balance $ polos 5 $ Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 103,000 July $ 48,000 February 96,000 August 48,000 March 28,000 September 58,000 April 28,000 October 88,000 May 23,000 November 100,000 June 38,000 December 126,000 Total annual sales - $792,000 Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per unit to produce. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by 12. of each month's sales, 30 percent are for cash and 70 percent ore on account. All accounts receivable are collected in the month after the sale is made a. Construct a monthly production and Inventory schedule in units. Beginning Inventory in January is 28,000 units. January February March April May June Bombs Away Video Games Corporation Production and Inventory Schedule in Units Beginning Production Sales Inventory 28,000 14200 20,600 20,600 13,200 19,200 14,500 13,200 5,600 22,200 13.200 5,600 29,800 13,200 4,000 38,400 13.200 7,600 Ending Inventory 20,600 14,600 22,200 29,800 38,400 44,000 UE SOIE is lllaue. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 28,000 units. January February March April May June July August September October November December Bombs Away Video Games Corporation Production and Inventory Schedule in Units Beginning Production Sales Inventory 28,000 13,200 20,600 20,600 13,200 19,200 14,600 13,200 5,600 22,200 13,200 5,600 29,800 13,200 4,600 38,400 13,200 7,600 44,000 13,200 9,600 47,600 13,200 9,600 51,200 13,200 11,600 52,800 13,200 17,600 48,400 13,200 21,600 40,000 13,200 25,200 Ending Inventory 20,600 14.600 22,200 29,800 38,400 44,000 47,600 51,200 52,800 48,400 40,000 28,000 b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. Bombs Away Video Games Corporation b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. Bombs Away Video Games Corporation Cash Receipts Schedule January February March 103,000 $ 96,000 $ 28,000 $ April 28,000 May 23,000 $ June 38,000 $ $ Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts $ 6,900 $ 30,900 $ 70,000 100,900 $ 28,800 $ 72,100 100,900 $ 8,400 $ 67,200 75,600 $ 8,400 $ 19,600 28,000 $ 19,600 26,500 $ 11,400 16,100 27,500 $ Bombs Away Video Games Corporation Cash Receipts Schedule July August September 48,000 $ 48,000 $ 58,000 $ October November December 88,000 $ 108,000 $ 126,000 $ Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts $ 14.400 $ 26,600 41,000 $ 14,400 $ 33,600 48,000 $ 17,400 $ 33,600 51,000 $ 26,400 5 40,600 67.000 $ 32,400 $ 61,600 94,000 $ 37,800 75,600 113,400 $ c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for in the month in which they occur. Other cash payments, besides those for production costs, are $48,000 per month. June Bombs Away Video Games Corporation Cash Payments Schedule January February March 26,400 $ 26,400 $ 26,400 S 48.000 48,000 48,000 74,400 $ 74,400 $ 74,400 S $ Production cost Other cash payments Total cash payments April 26,400 $ 48,000 74,400 $ May 26.400 $ 48,000 74,400 $ 26,400 48,000 74.400 $ Bombs Away Video Games Corporation Cash Payments Schedule July August September October November December 26,400 $ 26,400 5 26,400 $ 26,400 $ 26,400 $ 26,400 48,000 48,000 48,000 48,000 48,000 74 ao s 74,400 $ 74,400 $ 74,400 $ 74,400 $ 74.400 $ Production cost Other cash payments Total cash payments 48,000 $ June $ Beginning cash Net cash flow Cumulative cash balance Monthly loan or (repayment) Ending cash balance Cumulative loan balance Cash Budget January February March 5,000$ 31,500$ 58,000 $ 26.500 26,500 1,200 31,500 $ 58,000$ 59,200 $ OS 0$ 0$ 31.500$ 58,000 $ 50,200 $ OS 0 $ $ April 59.2005 (46,400) 12,800 $ 0 12,800 0 $ May 5,000 $ (47,900) (42,900) $ 47.900 5,000 $ 47,900 S $ $ IS $ 5,000 (46.900) (41.900) 46,900 5,000 94.800 Answer is complete but not entirely correct. Bombs Away Video Games Corporation Cash Budget July August September October November December 5,000$ 5,000$ 5.000 $ 5.000 5,000$ 5.000 (33,400) (26,400) (23.400) (7.400) 19,600 39.000 (28.400) (21.400) (18.400) (2.400) $ 24,600 $ 44,000 33.400 26,400 23.400 7400 (19.600) (39.000) 5.000S 5,000$ 5.000 IS 5,000 5,000 $ 5,000 128.2003 154.600 $ 178,000 $ 185,4003 165.800 $ 126 800 Beginning cash Not cash flow Cumulative cash balance Monthly loan or repayment) Ending cash balance Cumulative loan balance $ polos 5 $