Esquire Products Inc. expects the following monthly salos S 33,000 July S 27,000

Question

Esquire Products Inc. expects the following monthly salos S 33,000 July S 27,000 31,000 34,000 39,000 47,000 29,000 February 24,000 August 17,000 September 19,000 October 13,000 November 11,000 December June Total sales $324000 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 17,000 units Answer is complete and correct. Esquire Products Ine. Production and Inventory Schedule in Units Beginning Production SalesEnding 3,500 3,500 3,500 3,500 3,500 3,600 13,500 13,500 13,500 3,500 3,500 13,500 7,000 4,000 6,500 20,500 4,500 6,500 2,000 8,500 O 4,000 6,500 20,500 4 500 1,500 9,500 39,500 37,500 34,000 28,000 18,000 17,000 Febnaary March ,600 ,500 June July August 31,500 5,500 39,500 39,600 37,500 34,000 28,000 3,500 5,500 7,000 19,500 23,500 Deconbor 18000 14,500

Explanation / Answer

d ESQUIRE PRODUCTS INC CASH BUDGET January February March April May June July August September October November December Beginning Cash $3,000 $6,800 $14,800 $14,600 $11,000 $6,200 $3,000 $3,000 $3,000 $11,000 $25,600 $46,400 Net Cash flow 3800 8000 -200 -3600 -4800 -9200 -4000 7200 10800 14600 20800 18400 Cumulative Cash balance $6,800 $14,800 $14,600 $11,000 $6,200 ($3,000) ($1,000) $10,200 $13,800 $25,600 $46,400 $64,800 Monthly loan or (repayment) 0 0 0 0 0 $6,000 $4,000 ($7,200) ($2,800) $0 $0 $0 Ending Cash Balance $6,800 $14,800 $14,600 $11,000 $6,200 $3,000 $3,000 $3,000 $11,000 $25,600 $46,400 $64,800 Cumulative Loan Balance 0 0 0 0 0 6000 $10,000 $2,800 $0 $0 $0 $0 Net Cash flow - Cash Receipts- Cash Payments 25200-21400 29400-21400 21200-21400 17800-21400 16600-21400 12200-21400 17400-21400 28600-21400 32200-21400 36000-21400 42200-21400 39800-21400 e ESQUIRE PRODUCTS INC ASSETS Cash Accounts Receivable Inventory Total Current Assets Accounts Receivable working Inventory January $6,800 $19,800 $14,000 $40,600 33000*60% Ending units*$1 February $14,800 14400 $15,500 $44,700 24000*60% March $14,600 10200 $20,500 $45,300 17000*60% April $11,000 11400 $24,500 $46,900 19000*60% May $6,200 7800 $31,500 $45,500 13000*60% June $3,000 6600 $39,500 $49,100 11000*60% July $3,000 16200 $39,500 $58,700 27000*60% August $3,000 18600 $37,500 $59,100 31000*60% September $11,000 20400 $34,000 $65,400 34000*60% October $25,600 23400 $28,000 $77,000 39000*60% November $46,400 28200 $18,000 $92,600 47000*60% December $64,800 17400 $17,000 $99,200 29000*60%

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.