Need part E ONLY.

Esquire Products Inc. expects the following monthly sales: January February March April May June $ 28,000 July 19,000 August 12,000 September 14,000 October 8,000 November 6,000 December Total sales = $264,000 $ 22,000 26,000 29,000 34,000 42,000 24,000 Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for $2 each and produces them for $1 each. Esquire uses level production, and average monthly production is equal to annual production divided by 12. a. Generate a monthly production and inventory schedule in units. Beginning inventory in January is 12,000 units. Answer is complete and correct. Esquire Products Inc. Production and Inventory Schedule in Units Beginning + Production Sales Inventory 12,000 11,000 14,000 9,000 11,000 9,500 10,500 11,000 6,000 15,500 11,000 7,000 19,500 11,000 4,000 26,500 11,000 3,000 34,500 11,000 11,000 34,500 11,000 13,000 32,500 11,000 14,500 29,000 11,000 17,000 23,000 11,000 21,000 13,000 11,000 12,000 January February March April May June July August September October November December ololololo Ending Inventory 9,000 10,500 15,500 19,500 26,500 34,500 34,500 32,500 29,000 23,000 13,000 12,000 b. Prepare a cash receipts schedule for January through December. Assume that dollar sales in the prior December were $20,000. Answer is complete and correct. Esquire Products Inc. Cash Receipts Schedule February March 19,000 $ 12,000 January 28,000$ April 14,000$ May 8,000 $ June 6,000 $ Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts $ 11,200 $ 12,000 23,200 $ 7,600$ 16,800 24,400 $ 4,800 $ 11,400 16,200 5,600$ 7,200 12,800 $ 3,200 $ 8,400 11,600 2,400 4,800 7,200 $ $ $ Answer is complete and correct. Esquire Products Inc. Cash Receipts Schedule August September 26,000 29,000$ July 22,000$ October 34,000 November December 42,000$ 24,000 Sales $ $ Cash receipts: Cash sales Prior month's credit sales Total cash receipts 8,800$ 3,600 12,400 $ 10,400$ 13,200 23,600 11,600$ 15,600 27,200 $ 13,600$ 17,400 31,000 16,800$ 20,400 37,200 $ 9,600 25,200 34,800 $ S $ c. Prepare a cash payments schedule for January through December. The production costs ($1 per unit produced) are paid for in the month in which they occur. Other cash payments (besides those for production costs) are $7,400 per month. Answer is complete and correct. Esquire Products Inc. Cash Payments Schedule Constant production January February March 11,000$ 11,000 $ 11,000$ 7,400 7,400 7,400 18,400 $ 18,400 $ 18,400 $ $ Production cost Other cash payments Total cash payments April 11,000 $ 7,400 18,400 $ May 11,000 $ 7,400 18,400 June 11,000 7,400 18,400 $ Answer is complete and correct. Esquire Products Inc. Cash Payments Schedule Constant production August September 11,000 $ 11,000$ 7,400 7,400 18,400 $ 18,400 $ $ July 11,000$ 7,400 18,400 Production cost Other cash payments Total cash payments October November December 11,000 $ 11,000S 11,000 7,400 7,400 7,400 18,400 $ 18,400 $ 18,400 $ d. Construct a cash budget for January through December using the cash receipts schedule from part band the cash payments schedule from part c. The beginning cash balance is $3,000, which is also the minimum desired. (Negative amounts should be indicated by a minus sign.) $ Beginning cash Net cash flow Cumulative cash balance Monthly loan or (repayment) Ending cash balance Cumulative loan balance $ Answer is complete and correct. Esquire Products Inc. Cash Budget February March April 7,800$ 13,800 $ 11,600$ 6,000 (2.200) (5,600) 13,800 $ 11,600$ 6,000 $ 0 0 0 13,800 $ 11,600$ 6,000 $ 0$ 0$ 0$ January 3,000 $ 4,800 7,800 $ 0 7,800$ 0$ May 6,000$ (6,800) (800) $ 3,800 3,000 $ 3,800 $ June 3,000 (11,200) (8,200) 11,200 3,000 15,000 $ $ Answer is complete and correct. $ $ $ Beginning cash Net cash flow Cumulative cash balance Monthly loan or (repayment) Ending cash balance Esquire Products Inc. Cash Budget August September 3,000 $ 3,000 5,200 8,800 8,200 $ 11,800 (5,200) (8,800) 3,000 $ 3,000 15,800 $ 7,000 SI July 3,000 (6,000) (3,000) 6,000 3,000 21,000 December $ 27,400 16,400 $ 43,800 $ OK October November 3,000 $ 8,600 12,600 18,800 15,600 $ 27,400 (7,000) 0 8,600 $ 27,400 0 $ 0 $ $ 0 $ $ $ $ 43,800 Cumulative loan balance $ $ $ $ 0 e. Determine total current assets for each month. Include cash, accounts receivable, and inventory. The accounts receivable for a given month is equal to 60 percent of that month's sales. Inventory is equal to ending inventory (part a) times the cost of $1 per unit. x Answer is not complete. Esquire Products Inc. Assets Cash Accounts Receivable Inventory Total Current Assets $ 7,800 January February March 13,800 April May June July August September 11,600 6,000 3,000 3,000 3,000 3,000 3,000 8,600 27,400 43,800 October November December