Can you explain please step by step how to do it. THANKS

IF YOU CAN DO IT IN EXCEL MUCH BETTER :)

Level production and related financing effects (L06-3) 22. Esquire Products Inc. expects the following monthly sales: January $28,000 May $ 8,000 September $29.000 February 19,000 June 6,000 October 34.000 March 12,000 July 22,000 November 42,000 April 14,000 August 26,000 December 24,000 Total sales = $264,000 page 190 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 al 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. (Note: To do part a, you should work in terms of units of production and units of sales.) b. Determine a cash receipts schedule for January through December. Assume that dollar sales in the prior December were $20,000. Work part busing dollars. c Determine 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 57,400 per month d. Construct a cash budget for January through December using the cash receipts schedule from part band the cash payments schedule from partc. The beginning cash balance is $3,000, which is also the minimum desired. e. Determine total current assets for each month. Include cash, accounts receivable, and inventory. Accounts receivable equal sales minus 40 percent of sales for a given month. Inventory is equal to ending inventory (part a) times the cost of $1 per unit