Prepare a three-month cash budget

Reference no: EM131931776

Problem

	October	November	December
Sales	960,000	870,000	850,000
Direct Materials	123,000	119,000	125,000
Direct Labor	90,000	85,000	96,000
Variable Overhead	65,600	62,400	68,000
Fixed Overhead	140,000	140,000	140,000
Selling and Admin Costs	312,000	310,000	315,000
Fixed Loan Payments	140,000	140,000	140,000

Sales were $770,000 in August and $840,000 in September. Material usage was $115,000 in August and $118,000 in September. All sales are on account, and accounts receivable is historically collected 15% in the month of sale, 65% in the month following sales, and the remainder two months after the sale. Materials are paid for 40% in the month used and 60% the following month. All other expenses are paid in the month incurred. The cash balance was $35,000 at the beginning of October, and management wants to determine if the company will have enough cash to pay a year-end bonus.

Prepare a three-month cash budget, including a schedule for cash collections and material payments.

Reference no: EM131931776

Questions Cloud

Describe the leisurely and unfocused exploration : Describe the characteristics of the following different Problem-Solving paradigms: Leisurely and unfocused exploration etc.

Why go to all the trouble of sometimes costly : Why go to all the trouble of sometimes costly and time-consuming assessments when there are no guarantees they will result in a successful hire.

Create spreadsheet entries to record the given transactions : In journal entry form, create the spreadsheet entries to record these transactions for Collins Company's 2016 and 2017 statement of cash flows.

Compare and contrast two labour unions in a named country : Compare and Contrast two labour unions in a named country. Write your own outline, complete with thesis statement.

Prepare a three-month cash budget : Sales were $770,000 in August and $840,000 in September. Prepare a three-month cash budget, including a schedule for cash collections and material payments.

Describe the spaghetti sauce segmentation technique : How can you apply the "Spaghetti Sauce Segmentation Technique" that was first performed by Howard Moskowitz to your business.

Describe actions that manager might take to show improvement : describe actions that managers might take to show improvement in the performance measure but which do not actually lead to improvement in overall performance.

How you would position the company to move forward socially : The role of Chief Strategist for Life is Good and explain how you would position social responsibility to further both their social and strategic goals.

Explain why you agree or disagree with model listener : Describe the listening characteristics of an individual (personal or professional) who you consider to be an effective listening role model for you.

User Account

All Pages