Question

In: Accounting

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...

Estimated sales January February March April May

Total Coffee
sales (units) 15,000 16,000 18,000 17,500 14,500

Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has
asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his
depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied
you with the following information (above) to help you put together his cash budget.
The revenue for a coffee is $5 for a large, $4 for a medium and $3 for a small. 50% of his sales are Large
coffees, 25% medium and 25% smalls. Chris has a deal with an accounting company and half of the
coffees sold are on account, the other half pay cash. The accounting company pays for the coffees the
month after the sale. Assume credit sales are half of the total coffee sales.
Material and Labour information Chris has provided:

Large Medium Small
Labour hours 0.1 0.05 0.05
Coffee pods 3 2 1
Cost of a Coffee pod $0.90

Labour is paid at $20/hour. The Coffee pods need to be ordered a month in advance. He requires 10%
of next months total coffee pods to be on hand. The beginning coffee pod inventory, February 1, was
3,600 pods. 50% of the Coffee pods are paid in the month they are ordered, 50% are paid the following
month.

Other information Chris has provided:

February March April May
Rent 2,500 2,500 2,500 2,500
Dividend 3,000 15,000
Office and Admin 3,500 3,500 3,500 3,500
NOTE: Chris requires a minimum bank balance of $5,000 at the end of the month and the ending
January bank balance is $10,000. Chris has access to a line of credit of $500,000 at an interest rate of
30%. Borrowings are made at the beginning of the month and repayments are made at the end of the
month.


REQUIRED:
Using the Excel file included with the exam, for the months of February, March and April prepare
 Sales Budget, with a cash receipts.
o What is the A/R at the end of the month?
 Materials Budget, with cash disbursements.
o What is the A/P at the end of the month?
 Direct Labour Budget
 Cash budget

Solutions

Expert Solution


Related Solutions

Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units)...
Question 1: - Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, MATT, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told MATT his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information...
The following are budgeted data: Sales (units )Production (units) April 15,000 18,000 May 20,000 19,000 June...
The following are budgeted data: Sales (units )Production (units) April 15,000 18,000 May 20,000 19,000 June 18,000 16,000 Two pounds of material are required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. Purchases of raw materials for May should be: 36,800 pounds 39,200 pounds 52,000 pounds 38,000 pounds
Assume a company’s estimated sales for January, February, and March are 25,000 units, 27,000 units, and 24,000 units, respectively.
Assume a company’s estimated sales for January, February, and March are 25,000 units, 27,000 units, and 24,000 units, respectively. The company always maintains ending finished goods inventory equal to 15% of next month’s unit sales. What is the required production in units for January?
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s sales. The inventory...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020: 1.   Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The unit sales price is $125. All sales are on credit and collections are 30% in the month of sale, 60% the following month, and 10% two months following the sale. Accounts receivable as of the end of December is $4,600 and this amount is expected to be collected in January. 2. End of month inventory must equal 40% of next month’s...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019: 1.   Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April: 3,500 units. The unit sales price is $50. All sales are on credit and collections are 20% in the month of sale and 80% the following month. Accounts receivable as of December 31, 2018 is $15,000 and this amount is expected to be collected in January 2019. 2. End of month inventory must equal 60% of next month’s sales. The inventory at the end...
MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000...
MONTH UNITS TOTAL COSTS PRODUCED January 12,500 $430,000 February 17,000 $490,000 March 19,000 $512,000 April 10,000 $400,000 May 14,000 $434,000 June 9,000 $360,000 July 20,000 $550,000 August 21,000 $525,000 September 24,000 $605,000 October 23,000 $589,000 November 28,000 $702,000 December 18,000 $496,000 1) From this information, what are my approximate fixed costs and what is my estimated variable cost per product produced? (20 POINTS) Fixed Costs = Variable Cost per Unit = 2) If I manufacture 35,000 units this month, what...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second month. Monthly inventory purchases represent 50% of the following month’s sales. The firm pays 40% of its inventory purchases in cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT