Exam 9: The Master Budget

Warshaw Company budgets payroll at $3,600 per month plus a percentage of monthly sales. The June operating expense budget includes total payroll of $13,200 with budgeted sales of $160,000. Sales for July are budgeted at $180,000 while purchases of inventory for July are budgeted at $95,000. Depreciation and insurance for July are estimated at $1,000 and $600, respectively. Office and administrative expenses related to purchasing inventory are budgeted at 10% of purchases for the month. The purchase of $2,500 in equipment and $1,500 in furniture is expected in July. If the percentage of monthly sales used in budgeting payroll increases 25%, what would the total payroll budgeted for July be?

Carlton Cookie Company produces a hand-processed gourmet cookie that is made with organic sugar. Five (5)pounds of organic sugar are required per batch of gourmet cookies. The organic sugar costs $2.40 per pound. The company needs to have 20% of the following month's production needs of organic sugar in ending inventory so it is on hand to start each month. A total of 120 pounds of organic sugar are expected to be on hand on April 1. 1. Budgeted production of the gourmet cookies for the first four months of the upcoming year is as follows: Required: Prepare a direct materials budget for organic sugar for each of the months in the second quarter and for the second quarter in total. Include both the quantity of sugar to be purchased and the cost of the purchases in each month.

Which of the following types of companies use a capital expenditures budget?

Birch Company manufactures coffee makers. The following selected data relates to Birch Company's budgeted sales and inventory levels of the coffee makers for the upcoming quarter. How many coffee makers should Birch Company produce in November? Show your calculations.

In preparing the operating budget, the first step is preparing the

Rubino Corporation desires a December 31 ending inventory of 900 units. Budgeted sales for December are 2,650 units. The November 30 inventory was 850 units. What are budgeted purchases in units?

Sally Scooters manufactures and sells scooters. Each scooter requires two rear view mirrors. For September, Sally Scooters has budgeted sales of 415 scooters, while 450 scooters are scheduled to be produced. Sally Scooters will begin September with 220 rear view mirrors in its beginning inventory. How many rear view wheels should Sally Scooters purchase for September?

Two Brothers Moving prepared the following sales budget: Credit collections are 25% in the month of sale, 60% in the month following the sale, and 10% two months following the sale. The remaining 5% is expected to be uncollectible. What is the total cash received in April from April sales?

Kennedy Enterprises has budgeted sales for the months of September and October at $120,000 and $150,000, respectively. Monthly sales are 70% credit and 30% cash. Of the credit sales, 20% are collected in the month of sale and 80% are collected in the following month. What are the October cash collections from customers?

Which of the following types of companies use a "cost of goods sold, inventory, and purchases" budget?

Cave Hardware's forecasted sales for April, May, June, and July are $200,000, $230,000, $190,000, and $240,000, respectively. Sales are 65% cash and 35% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75% of sales and ending inventory is maintained at $60,000 plus 10% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78% in the following month. What are the cash collections budgeted for June?

Merchandising companies prepare a direct materials budget.

A company's plan for purchases of property, plant, equipment, and other long-term assets is part of the budgeted balance sheet.

Piatt Company expects cash sales for July of $15,000, and a 26% monthly increase during August and September. Credit sales of $12,000 in July should be followed by 30% increases during August and September. What are budgeted cash sales and budgeted credit sales for September respectively?

Mighty Corporation manufactures end tables. Each end table requires .50 direct labor hours in its production. Mighty Corporation has a direct labor rate of $15 per direct labor hour. The production budget shows that Mighty Corporation plans to produce 1,000 end tables in March and 1,100 end tables in April. What is the total combined direct labor cost that should be budgeted for March and April?

Budgeting is helpful to plan for cash inflows and outflows.

The Porch Cushion Company manufactures foam cushions. The number of cushions to be produced in the upcoming three months follows: Each cushion requires 2 pounds of the foam used as stuffing. The company has a policy that the ending inventory of foam each month must be equal to 25% of the following month's expected production needs. How many pounds of foam does The Porch Cushion Company need to purchase in August?

Fosnight Enterprises prepared the following sales budget: The expected gross profit rate is 30% and the inventory at the end of February was $10,000. Desired inventory levels at the end of the month are 20% of the next month's cost of goods sold. What is the desired ending inventory on May 31?

Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000; respectively. Sales are 65% cash and 35% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75% of sales and ending inventory is maintained at $60,000 plus 10% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78% in the following month. What is the balance of accounts payable on the June 30 budgeted balance sheet?

Distribution Corporation collects 40% of a month's sales in the month of sale, 55% in the month following sale, and 5% in the second month following sale. Budgeted sales for the upcoming four months are: The amount of cash that will be collected in July is budgeted to be