Prepare a three-month cash budget including a schedule

Reference no: EM131961012

Problem

Presented below are selected budget data items for Globe Corporation for a three-month period: October November December Sales $908,000 $891,000 $887,000 Direct materials 127,700 124,000 129,000 Direct labor 94,000 95,000 96,400 Variable overhead 67,900 69,250 71,000 Fixed overhead 145,000 145,000 145,000 Selling and Administrative expenses 309,000 310,820 312,600 Fixed loan payments 135,100 135,100 135,100 Sales were $820,000 in August and $865,500 in September. Material usage was $117,100 in August and $121,800 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 35% in the month used and 65% the following month. All other expenses are paid in the month incurred. The cash balance was $42,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: EM131961012

Questions Cloud

Conduct a study to examine phenomenon : Conduct a study to examine this phenomenon with a sample size of n=14. What is the probability that 11 or less, or more than 14 children become sick?

Result in at least five new customers : What are the probabilities that contacting 25 potential customers would result in at least five new customers? Need this done in excel with graph.

Calculate the income needed next year to achieve the goal : The president of Minor Industries and her department managers. Calculate the income needed next year to achieve the goal of a 20% return on total assets.

Draw a possibility tree for situation : Draw a possibility tree for your situation and answer the question: have you made a good bet (what is the likelihood of being correct?

Prepare a three-month cash budget including a schedule : Presented below are selected budget data items for Globe. Prepare a three-month cash budget, including a schedule for cash collections and material payments.

Demand for batteries : Daniel Baker owns a shop that sells special car batteries. He uses a monthly periodic review order policy, and sets a 95% service level

Find the optimal ordering policy for double a : If an item is out of stock, they will place the item on backorder and estimate that the cost of lost goodwill is $.20. Find the optimal ordering policy for Doub

Calculate medtechs accounts receivable turnover ratio : Calculate Medtech's accounts receivable turnover ratio for 2018 and 2017. What could have caused the change? Explain.

Basic black dress shoe for men : 1.) Kelvin Shoe Stores carries a basic black dress shoe for men that sells at a rate of 500 each quarter.

User Account

All Pages