Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Esquire Products Inc. expects the following monthly sales: January $ 45,000 July $ 39,000 February 36,000 August 43,000 March 29,000 September 46,000 April 31,000 October
Esquire Products Inc. expects the following monthly sales:
January | $ | 45,000 | July | $ | 39,000 |
February | 36,000 | August | 43,000 | ||
March | 29,000 | September | 46,000 | ||
April | 31,000 | October | 51,000 | ||
May | 25,000 | November | 59,000 | ||
June | 23,000 | December | 41,000 | ||
Total sales = $468,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 29,000 units. Esquire Products Inc. Production and Inventory Schedule in Units Beginning Production Sales Ending Inventory 29,000 anuary February March April June July August September October November December b. Prepare a cash receipts schedule for January through December, Assume that dollar sales in the prior December were $20.000 Esquire Products Inc. Cash Receipts Schedule January February March April June Cash receipts Cash sales Prior month's credit sales Total cash receipts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started