Chapter 5 Complete Test Bank Planning And Forecasting Davis - Test Bank | Managerial Accounting 4th Edition by Davis Davis by Davis Davis. DOCX document preview.
Chapter 5
Planning and Forecasting
CHAPTER LEARNING OBJECTIVES
- Describe the budget development process and explain how it fits into management’s planning process. (Unit 5.1)
Budgets can be completed in either a top-down, imposed process or a bottom-up, participative process. Either way, the process is iterative, as information is passed throughout the organization and updated for changes in planned activity. Budgets can be prepared using the prior year’s budget as a starting point, or they can be prepared using zero-based budgeting, in which each item must be justified anew each year. A budget may be prepared to cover a monthly, quarterly, or annual time frame.
Executive management sets out a strategy to guide a company’s actions. The budgeting process translates that strategy into action by allocating financial resources across the organization, to ensure that the necessary steps can be taken. The budget also communicates decisions about resource allocation throughout the organization, allowing managers to plan for the future in order to mitigate potential operational risks, such as cash shortages.
- Calculate the standard cost of a product. (Unit 5.2)
To calculate the standard cost of a product, multiply the standard price of each input (direct materials, direct labor, and manufacturing overhead) by the standard quantity of the input and sum. The standard cost is the expected cost to manufacture one unit of output.
Price standards are the expected cost of obtaining each input used in producing a product.
- The direct materials price standard includes the cost of getting the materials to the factory (purchase price, freight, and discounts)
- The direct labor price standard includes wages, fringe benefits, and payroll taxes.
- The manufacturing overhead price standard is the predetermined overhead rate.
Quantity standards are the expected amount of inputs required to produce one good unit of output.
- The direct materials quantity standard is the quantity of direct materials needed to produce one unit of good output, including allowances for waste and spoilage.
- The direct labor quantity standard is the amount of direct labor time required to produce one good unit of output.
- The manufacturing overhead quantity standard is based on usage of the overhead application base.
- Prepare the operating budget and describe the relationships among its components. (Unit 5.3)
The operating budget begins with the creation of the sales budget. Once budgeted sales have been forecast, a selling and administrative expense budget to support that level of sales is calculated. The sales budget also provides input for the production budget, which details when and how much of a product must be produced. Once budgeted production is known, the direct materials purchases, direct labor, and manufacturing overhead budgets can be prepared to support the acquisition of the required inputs.
- The sales budget is a forecast of expected sales, expressed in both units and dollars. This budget is the key to the entire master budgeting process, since most other master budget components depend on the level of sales.
- The selling and administrative expense budget details all the expenditures for selling and administrative expenses.
- The production budget determines the level of production required to meet budgeted sales and maintain desired levels of ending Finished Goods Inventory.
- The direct materials purchases budget shows the quantity of direct materials that will be needed to meet the production requirements shown in the production budget and maintain the desired ending inventory of direct materials. This budget also shows the quantity of direct materials that must be purchased.
- The direct labor budget shows how many direct labor hours must be incurred to meet the budgeted level of production.
- The manufacturing overhead budget details the fixed and variable overhead costs to be incurred.
- Prepare the cash budget and describe the relationships among its components. (Unit 5.4)
The cash budget is comprised of the following sections:
- The cash available to spend section of the cash budget shows how much cash is available to spend in each period. It includes the beginning Cash balance and Cash collections from sales shown in the cash receipts budget.
- The cash disbursements section of the cash budget lists all budgeted cash disbursements. In addition to various planned operational disbursements, such as equipment purchases and debt service payments, the cash disbursements section includes information from the cash payments for materials, direct labor, manufacturing overhead, and selling and administrative expense budgets.
- The cash excess (cash needed) section of the cash budget subtracts the budgeted cash disbursements from the budgeted cash available to spend to determine the cash excess or shortage. It includes any minimum Cash balance required.
- The short-term financing section of the cash budget details the short-term financing activities needed to maintain an adequate Cash balance. It is completed only if additional short-term borrowings or repayments of existing short-term borrowings or interest are required.
- The ending Cash balance is determined by the following formula:
Cash available to spend – Cash disbursements = Cash excess or cash needed
Cash excess or cash needed + Short-term financing = Ending cash balance
- The ending Cash balance should always be at least as much as the minimum Cash balance required.
- The ending Cash balance for one period is the beginning Cash balance for the next period.
- Prepare pro-forma financial statements and describe their relationship to the master budget components. (Unit 5.5)
Pro-forma income statements and balance sheets are prepared using the information developed in the budget process. These statements reflect the results of operations and the financial position of the organization as if all actions planned in the budget had occurred. Many of the master budget components provide direct input to the pro-forma financial statements, as follows:
Budget Component | Income Statement Accounts | Balance Sheet Accounts |
Sales budget | Revenue | |
Selling and administrative expense budget | Selling and Administrative Expense | Accumulated Depreciation |
Manufacturing overhead budget | Accumulated Depreciation | |
Ending inventory and cost of goods sold budget | Cost of Goods Sold | Raw Materials Inventory, Work in Process Inventory, Finished Goods Inventory |
Cash receipts budget | Bad Debt Expense | Accounts Receivable |
Cash payments for materials budget | Accounts Payable | |
Cash budget | Interest Expense | Cash, Accrued Expenses, Equipment, Short- and/or Long-term Debt |
TRUE-FALSE STATEMENTS
- Budgeting is ineffective unless it is tied to strategy and used to manage an organization’s overall performance.
- A budget is an operating plan that may be expressed in either financial or non-financial terms.
LO: 1, Bloom: K, Unit: 5-1, Difficulty: Easy, Min: 1, AACSB: Analytic, AICPA FN: Reporting, AICPA PC: None, IMA: Strategy
- Budgets assist managers in the areas of planning, controlling, evaluating, and decision-making.
- Top-down budgeting is also referred to as participative budgeting.
- In a bottom-up budget approach, at each higher level of management, the budget is reviewed and may be altered to satisfy the competing needs of various units within the organization.
- Bottom-up budgeting is also referred to as a participative budgeting.
- A bottom-up approach to budgeting is circular while a top-down approach is linear.
- Deviations from the budget can occur because of good decisions, bad decisions, or events.
- Both the top-down and bottom-up approaches to budgeting are linear, with budget information flowing in a single direction.
- Budgetary slack is more common in a top-down approach to budgeting than in a bottom-up approach.
- The most popular way to begin the budgeting process is the incremental approach.
- Zero-based budgeting is not as time consuming as incremental budgeting.
- A rolling budget always includes 12 months of data and as one month ends, it is removed from the budget and the entire budget rolls forward one month.
- Performance-standard setting is not an exact science, but there are some hard and fast criterion for proving one standard right and the other one wrong.
- Practical standards represent a level of performance that can be attained with reasonable effort.
- Ideal standards represent a level of performance that can be attained with reasonable effort.
- Since the purchasing agent is responsible for ordering raw materials, he or she would be the one to negotiate a volume discount.
- If practical standards are used, the standard quantity for direct materials should not include allowances for waste and spoilage in the normal course of manufacturing.
- The terms standard price and standard cost can be used interchangeably.
- Standard direct labor prices are also referred to as direct labor rates.
- The direct labor quantity standard is the number of products that can be produced in one hour.
- The predetermined overhead rate is calculated as: Budgeted Total Manufacturing Overhead divided by Budgeted Activity Level of Application Base.
- The master budget is a collection of smaller budgets that lead to pro-forma financial statements.
- The first component of the master budget is the cash budget.
- Since the cash budget drives all other components of the master budget, it is imperative that it be as realistic as possible.
- To prepare the sales budget, multiply the forecasted sales units by the budgeted sales price per unit.
- The formula for the production budget is Budgeted Sales + Budgeted Beginning Inventory – Budgeted Ending Inventory = Budgeted Production.
- The key inputs for the direct materials purchases budget are the production budget and the direct materials standards for each project.
- The final component of the operating budget is the ending inventory and cost of goods sold budget.
- The first section of the cash budget reconciles the cash available to the borrowing required to meet the minimum cash balance.
LO: 4, Bloom: K, Unit: 5-4, Difficulty: Easy, Min: 1, AACSB: Analytic, AICPA FN: Reporting, AICPA PC: None, IMA: Strategy
- Pro-forma financial statements are prepared based on assumed rather than actual results.
Answers to True-False Statements
Item | Ans | Item | Ans | Item | Ans | Item | Ans |
1. | T | 9. | F | 17. | T | 25. | F |
2. | F | 10. | F | 18. | F | 26. | T |
3. | T | 11. | T | 19. | F | 27. | F |
4. | F | 12. | F | 20. | T | 28. | T |
5. | T | 13. | T | 21. | F | 29. | T |
6. | T | 14. | F | 22. | T | 30. | F |
7. | F | 15. | T | 23. | T | 31. | T |
8. | T | 16. | F | 24. | F |
MULTIPLE-CHOICE QUESTIONS
- Preparing a budget allows managers to
- plan for the future.
- reduce the need for unprepared responses to unexpected situations.
- assess whether a division’s strategic direction is in line with corporate strategy.
- Preparing a budget does not allow managers to
- eliminate any variances that would have been created without a budget.
- help divisions within the organization to communicate with one another.
- assess whether a division’s strategic direction is in line with corporate strategy.
- Budgets assist managers which of the following aspects of management?
- Planning
- Controlling
- Evaluating
- Budgets assist managers in all the following aspects of management except
- planning.
- controlling.
- leading.
- evaluating.
- Which of the following is not a characteristic of a top-down budget environment?
- Executive management creates the budget.
- This approach is referred to as participative budgeting.
- The budget is pushed down through the organization.
- A top-down budget approach is also referred to as
- participative budgeting.
- imposed budgeting.
- responsibility budgeting.
- Which of the following is not a characteristic of a bottom-up budget environment?
- Executive management creates the budget.
- At each higher level of management, the budget is reviewed and may be altered.
- The budget approach may also be referred to as participative budgeting.
- A bottom-up budget approach is also referred to as
- participative budgeting.
- imposed budgeting.
- responsibility budgeting.
- reverse budgeting.
- Which of the following budget approaches will produce a more accurate budget?
- Participative budgeting.
- Imposed budgeting.
- Responsibility budgeting.
- Which of the following is a disadvantage of participative budgeting?
- It is considering to be rolling throughout each budget period.
- Managers may pad the budget.
- It is a method of tactical planning.
- It requires each amount to be justified each budget period.
- An imposed budget
- tends to elicit more commitment to the budget from employees since they have had some input into its creation.
- begins at the lowest levels of management and filters up through the organization.
- is the least efficient method of budget preparation.
- involves the fewest number of people in the budgeting process.
- Which of the following is not a characteristic of a participative budget?
- It will produce a more accurate budget than an imposed budget.
- It tends to elicit more commitment to the budget than a top-down budget.
- It is the most efficient method of budget preparation.
- It is a time-consuming process as many people must provide input.
- Under both participative budgeting and imposed budgeting, the process is
- linear.
- iterative.
- curvilinear.
- Deviations from the budget may occur because of
- bad decisions.
- events beyond the company’s control.
- good decisions.
- Undesirable behavior is especially common in a bottom-up budget environment because managers
- may be required to explain unfavorable outcomes for amounts for factors they are able to control that caused the outcomes.
- have the ability to include budgetary slack to increase his or her chances of receiving a favorable performance evaluation.
- tend to employ tactical planning.
- do not control excess spending, and often exceed budgeted expenses.
- Budgetary slack is also referred to as
- budgetary padding.
- bottom-up slack.
- top-down slack.
- tactical planning.
- A manager estimates that revenues for the coming period will be $85,000 but includes only $80,000 in her budget. This is an example of
- pro-forma variance.
- revenue slack.
- budgetary padding.
- unfavorable planning.
- Which of the following is not a consequence of budgetary slack?
- Resources may not be allocated in the optimal way.
- Those who implement the budget may engage in undesirable behavior because they had input into setting the budget.
- Managers may receive bonuses they would not have earned if the budget had been prepared realistically.
- The pro-forma budgets may not be representative of actual expectations.
- Which of the following is not a behavioral issue related to a top-down budgeting environment?
- Employees may feel that an imposed budget is unfair.
- Employees will have no motivation to attempt to meet the budget.
- Employees may engage in budgetary padding.
- The organization’s resources may be wasted.
- Which of the following is the most popular way to begin the budgeting process?
- The incremental approach
- Zero-based approach
- Rolling approach
- Padding approach.
- Which of the following budget approaches begins each year at $0 and each individual budget item must be justified?
- Dollar value-based budgeting
- Governmental-based budgeting
- Justification-based budgeting
- Zero-based budgeting
- Which of the following is not a characteristic of zero-based budgeting?
- This method of budgeting is often used in governmental entities.
- This method of budgeting is much more time-consuming than incremental budgeting.
- This method of budgeting encourages budgetary slack.
- Which of the following is not a characteristic of a rolling budget?
- This method of budgeting always includes 12 months of data.
- As one month ends, it is removed from the budget and the entire budget rolls forward one month.
- At the beginning of the budget period, management breaks down only the first quarter into months.
- It requires a top-down approach.
- Sara Speed requested $120,000 in her budget to cover salary expenses. However, Sara realistically expects to spend $110,000 on salaries. This is an example of
- top-down budgeting.
- operating income padding.
- rolling budgeting.
- budgetary slack.
- An ideal standard signifies
- perfection.
- realistic projections.
- attainable goals.
- padding.
- In a manufacturing setting, practical standards do not allow for
- machine breakdowns.
- employee fatigue.
- vacations.
- excess employee idleness.
- Which of the following is not a criticism of ideal standards?
- After a period of performing below standard, employees will likely lose motivation.
- Morale will suffer because employees cannot attain the standard.
- In an effort to meet an ideal efficiency standard, employees may take shortcuts.
- They encourage employees to achieve high levels of performance.
- Which of the following is not a criticism of ideal standards?
- Product quality may decline if standards are not met.
- Employee morale will suffer if standards are not met.
- Employees may take shortcuts in order to meet the standards.
- Employees will perform with zero defects.
- Which of the following is an advantage of ideal standards?
- Employees will be motivated.
- Employees will take pride in their work.
- Employee morale will be high.
- Workers operate at 100% efficiency.
- A company may set standards for the maximum cost that should be incurred to produce a unit of product. Such cost standards are useful
- in the directing process.
- in evaluating how well manufacturing operations are managed.
- in achieving zero defects.
- In implementing a rolling budget.
- Direct materials standards specify both
- quantity and efficiency.
- quantity and price.
- efficiency and price.
- quality and usage.
- In the manufacturing of swimsuits, in addition to the price of fabric, the standard materials price does not include
- cost of shipping.
- volume discounts.
- taxes.
- units of material used.
- In the manufacturing of swimsuits, in addition to the price of fabric, the standard materials price includes all of the following items except
- the cost of shipping.
- the cost of advertising.
- a volume discount.
- sales taxes.
- The position responsible for negotiating a volume discount is the
- purchasing agent.
- production manager.
- accounts payable supervisor.
- corporate controller.
- The standard cost of direct material is the
- standard price of direct material input × standard quantity of direct material inputs.
- standard price of direct material input × actual quantity of direct material inputs.
- actual price of direct material input × standard quantity of direct material inputs.
- actual price of direct material input × actual quantity of direct material inputs.
- The difference in standard price and standard cost of direct material is that
- standard price is the amount to produce one unit of product; standard cost is the amount paid to obtain one unit of material from a vendor.
- standard price is the amount paid to obtain one unit of material from a vendor; standard cost is the amount to produce one unit of product.
- standard price is the amount added to work in process as material is put into production; standard cost is the amount to produce one unit of product.
- standard price is the amount to produce one unit of product; standard cost is the amount added to work in process as material is put into production.
- The standard price of direct labor includes all of the following except
- payroll taxes.
- health insurance.
- retirement contributions.
- employee-paid union dues.
- The standard price of direct labor does not include which of the following items?
- FICA taxes
- health insurance
- retirement contributions
- vacation pay.
- The amounts to be included in the standard price of direct labor are generally determined by
- each employee’s supervisor.
- the plant manager.
- the payroll department.
- the CFO.
- The amounts to be included in the standard price of direct labor are generally provided by
- each employee’s supervisor.
- the human resources department.
- the plant manager.
- the controller.
- Because people talk about wage rates rather than wage prices, we refer to standard direct labor prices as direct labor rates, expressed as
- per direct labor hour.
- per unit.
- a percentage.
- per direct labor dollar.
- The time needed to produce one unit of product is referred to as
- the direct labor efficiency standard.
- the direct labor time standard.
- the direct labor quantity standard.
- the direct labor standard.
- In setting the direct labor quantity standard, allowances are made for
- wage rate changes.
- employee terminations.
- cost of time inefficiencies.
- excess use of materials.
- In setting the direct labor quantity standard, allowances are made for
- rest time.
- overtime pay.
- payroll taxes.
- fringe benefits.
- In setting the direct labor quantity standard, allowances are made for such items as rest time and machine down-time, based on estimates made by
- the controller.
- the engineering department.
- the human resources department.
- production workers.
- In setting the direct labor quantity standard, estimated time can be derived from
- published labor rates in benchmark studies.
- time-and-motion studies.
- union contracts.
- payroll records.
- The calculation for the standard direct labor cost is
- standard wage rate per direct labor hour × actual quantity of direct labor hours.
- standard wage rate per direct labor hour × standard quantity of direct labor hours.
- actual wage rate per direct labor hour × standard quantity of direct labor hours.
- actual wage rate per direct labor hour × actual quantity of direct labor hours.
- The predetermined overhead rate is calculated by
- dividing the budgeted activity level of application base by the budgeted total manufacturing overhead.
- multiplying the budgeted activity level of application base by the budgeted total manufacturing overhead.
- dividing the budgeted total manufacturing overhead by the budgeted activity level.
- multiplying the budgeted total manufacturing overhead by the budgeted activity level.
- ABC Corporation allocates overhead based on direct labor cost. Assume ABC expects to incur a total of $1,025,000 in overhead costs and $820,000 in direct labor costs. Actual overhead costs incurred totaled $1,050,000 and actual direct labor costs totaled $800,100. ABC’s predetermined overhead rate is closest to
- 125% of direct labor cost.
- 128% of direct labor cost.
- 98% of direct labor costs.
- 100% of direct labor costs.
- Overhead is typically divided into which of the following components?
- Direct and indirect
- Fixed and variable
- Product and period
- Controllable and non-controllable.
- Jody Jewelry manufactures jewelry. In October Jody is planning to make 500 rings, 400 bracelets, and 210 pendants. Each ring requires 3 ounces of gold and 2 semi-precious stones. Each bracelet requires 4 ounces of gold and 4 semi-precious stones. Each pendant requires 3.5 ounces of gold and 1 semi-precious stone. The company can purchase the 10k gold it uses in its manufacturing for $215 an ounce, and can purchase a lot of 100 semi-precious stones for $3,080. What is the standard cost for direct materials per pendant?
- $245.80
- $783.30
- $752.50
- $3,295.00
- Jody Jewelry manufactures jewelry. In October Jody is planning to make 500 rings, 400 bracelets, and 210 pendants. Each ring requires 3 ounces of gold and 2 semi-precious stones. Each bracelet requires 4 ounces of gold and 4 semi-precious stones. Each pendant requires 3.5 ounces of gold and 1 semi-precious stone. The company can purchase the 10k gold it uses in its manufacturing for $215 an ounce, and can purchase a lot of 100 semi-precious stones for $3,080. What is the standard cost for direct materials per bracelet?
- $338.20
- $983.20
- $890.80
- $245.80
- Jody Jewelry manufactures jewelry. It applies overhead based on direct labor hours. In October Jody is planning to make 500 rings, 400 bracelets, and 210 pendants. The company expects the total manufacturing overhead for the year would be $3,450,000 and that total direct labor hours for the year would be 75,000. Actual overhead incurred for October was $295,920. Each ring requires 6.25 hours of labor to manufacture; each bracelet requires 5.5 hours of labor to manufacture, and each pendant requires 4 hours of labor to manufacture. What is the standard overhead cost per ring?
- $46.00
- $287.50
- $300.00
- $48.00
- Jody Jewelry manufactures jewelry. It applies overhead based on direct labor hours. In October Jody is planning to make 500 rings, 400 bracelets, and 210 pendants. The company expects the total manufacturing overhead for the year would be $3,450,000 and that total direct labor hours for the year would be 75,000. Actual overhead incurred for October was $295,920. Each ring requires 6.25 hours of labor to manufacture; each bracelet requires 5.5 hours of labor to manufacture, and each pendant requires 4 hours of labor to manufacture. What is the standard overhead cost per bracelet?
- $46.00
- $253.00
- $264.00
- $48.00
- Kandy Harts manufactures custom T-shirts. Each T-shirt can be imprinted front and back with photos, company logos or other information. Each T-shirt requires 2 ounces of ink, 15 minutes of direct labor (processing, folding, packaging), and a plastic bag for packaging. The following information is available regarding costs:
Short-sleeve T-shirts, 100-pack | $350.00 |
Long-sleeve T-shirts, 100-pack | 400.00 |
Direct labor, per hour | 16.00 |
Ink, 32-ounce bottle | 16.00 |
Plastic bags, 100-pack | 8.00 |
Kandy applied overhead at a rate of $9.40 per direct labor hour, and fringe benefits for workers are an additional 20% of wages. What is the standard price and standard quantity for direct labor?
- $16.00; 0.25 hour
- $19.20; 0.25 hour
- $4.80; 1 hour
- $4.80; 0.25 hour
- Kandy Harts manufactures custom T-shirts. Each T-shirt can be imprinted front and back with photos, company logos or other information. Each T-shirt requires 2 ounces of ink, 15 minutes of direct labor (processing, folding, packaging), and a plastic bag for packaging. The following information is available regarding costs:
Short-sleeve T-shirts, 100-pack | $350.00 |
Long-sleeve T-shirts, 100-pack | 400.00 |
Direct labor, per hour | 16.00 |
Ink, 32-ounce bottle | 16.00 |
Plastic bags, 100-pack | 8.00 |
Kandy applied overhead at a rate of $9.40 per direct labor hour, and fringe benefits for workers are an additional 20% of wages. What is the standard price and standard quantity for manufacturing overhead?
- $11.28; 0.25 hour
- $9.40; 0.25 hour
- $2.35; 1 hour
- $2.82; 0.25 hour
- Kandy Harts manufactures custom T-shirts. Each T-shirt can be imprinted front and back with photos, company logos or other information. Each T-shirt requires 2 ounces of ink, 15 minutes of direct labor (processing, folding, packaging), and a plastic bag for packaging. The following information is available regarding costs:
Short-sleeve T-shirts, 100-pack | $350.00 |
Long-sleeve T-shirts, 100-pack | 400.00 |
Direct labor, per hour | 16.00 |
Ink, 32-ounce bottle | 16.00 |
Plastic bags, 100-pack | 8.00 |
Kandy applied overhead at a rate of $9.40 per direct labor hour, and fringe benefits for workers are an additional 20% of wages. What is the standard price of producing one short-sleeve T-shirt?
- $10.65
- $11.73
- $10.73
- $12.23
$3.50 + $1.00 + $0.08 + $4.80 + $2.35 = $11.73
- Kandy Harts manufactures custom T-shirts. Each T-shirt can be imprinted front and back with photos, company logos or other information. Each T-shirt requires 2 ounces of ink, 15 minutes of direct labor (processing, folding, packaging), and a plastic bag for packaging. The following information is available regarding costs:
Short-sleeve T-shirts, 100-pack | $350.00 |
Long-sleeve T-shirts, 100-pack | 400.00 |
Direct labor, per hour | 16.00 |
Ink, 32-ounce bottle | 16.00 |
Plastic bags, 100-pack | 8.00 |
Kandy applied overhead at a rate of $9.40 per direct labor hour, and fringe benefits for workers are an additional 20% of wages. What is the standard price of producing one long-sleeve T-shirt?
- $11.15
- $12.23
- $11.23
- $11.73
$4.00 + $1.00 + $0.08 + $4.80 + $2.35 = $12.23
- Tanger Products plans to produce 10,000 units in January. Each unit requires 3 pounds of plastic, which costs $2 per pound. What standard material cost would the company use to plan for production?
- $2
- $6
- $3,333
- $5,000
- A collection of smaller budgets that leads to pro-forma financial statements is referred to as the
- master budget.
- summary budget.
- overall budget.
- pro-forma budget.
- Which of the following is not a component of the master budget?
- Indirect cost budget
- Direct material purchases budget
- Ending inventory and cost of goods sold budget
- Production budget
- Which of the following is not a component of the master budget?
- Manufacturing overhead budget
- Gross profit budget
- Ending inventory and cost of goods sold budget
- Production budget
- Which of the following is not a component of the master budget?
- Selling and administrative expenses budget
- Ending inventory and cost of goods sold budget
- Capital expenditures budget
- Sales budget
- Which of the following is not a component of the master budget?
- Budgeted income statement
- Direct material purchases budget
- Ending inventory and cost of goods sold budget
- Budgeted statement of cash flows.
- The first component of the master budget is the
- cash budget.
- overhead budget.
- pro-forma budget.
- sales budget.
- Development of the operating budget begins with the
- cash budget.
- sales budget.
- overhead budget.
- pro-forma budget.
- Which of the following is not a consequence of a sales budget developed by an overly optimistic marketing department?
- Too much inventory may be produced.
- Too much material will be ordered.
- The company will fail to achieve its budgeted income.
- More cash will be on hand than anticipated.
- In order to prepare the sales budget, one needs the number of units
- expected to be produced and the prices expected to be charged.
- expected to be sold and the cost of producing each unit.
- expected to be sold and the prices expected to be charged.
- sold in the previous period and the price charged for the units.
- Which of the following use information from the selling and administrative expense budget?
- Manufacturing overhead budget and cash budget
- Budgeted income statement and cash budget
- Cash budget and budgeted balance sheet
- Production budget and budgeted income statement.
- Which of the following budgets uses information from the selling and administrative expense budget?
- Pro-forma budget
- Budgeted income statement
- Direct materials purchases budget.
- Which of the following is not a step in preparing the production budget?
- Add beginning inventory units to required units to determine the budgeted production.
- Enter budgeted sales units from the sales budget.
- Calculate budgeted ending inventory units for the period.
- Add budgeted ending to budget sales units.
- Which of the following is not a use of the materials purchases budget?
- It helps managers minimize the resources invested in inventory.
- It helps managers plan the quantity and timing of purchases of material.
- It helps ensure the adequate level of inventory.
- It helps determine the number of units of product to produce.
104. Which of the following is not a step in preparing the direct materials purchases budget?
- Enter the budgeted sales from the sales budget.
- Calculate the direct materials production needs by multiplying the number of units to be produced by the direct material standard quantity for one unit.
- Calculate the total direct materials required for the period by adding the ending inventory to the direct materials production needs.
- Calculate the required purchases by subtracting the beginning direct materials balance from the total direct materials required for the period.
- One amount that the direct labor budget calculates is the number of
- direct labor hours required to meet the units in the sales budget.
- direct and indirect labor hours required to meet the units in the sales budget.
- direct labor hours required to meet the budgeted level of production.
- direct and indirect labor hours required to meet the budgeted level of production.
- Which of the following is not a step in preparing the manufacturing overhead budget?
- Enter the total estimated overhead from the previous period.
- Calculate the variable overhead cost per period using the variable rate and the budgeted activity base.
- Subtract the non-cash overhead items from the total overhead cost to determine cash payments for overhead.
- Calculate the total overhead cost for the period by adding the fixed and variable overhead costs.
- Total budgeted manufacturing overhead flows to the
- ending inventory and cost of goods sold budget.
- production budget.
- cash budget.
- the cost of goods sold budget.
- Information from the manufacturing overhead budget flows to the
- direct materials purchases budget.
- cash budget.
- production budget.
- sales budget.
- The final component of the operating budget is the
- cash budget.
- budgeted balance sheet.
- sales budget.
- ending inventory and cost of goods sold budget.
- Mounce, Inc. produces and sells free-standing quilt frames. In budgeting for production needs, the company requires that 10% of the next month’s sales be on hand at the end of each month. Budgeted sales of quilt frames over the next four months are:
September | October | November | December | |
Budgeted unit sales | 25,000 | 32,000 | 56,000 | 48,000 |
Budgeted production for October is
- 26,650.
- 34,400.
- 35,100.
- 37,600.
- Mounds Company has provided you with the following sales data.
September | October | November | December | |
Budgeted unit sales | 20,000 | 30,000 | 50,000 | 40,000 |
The company requires that 5% of the next month’s sales be on hand at the end of each month. Budgeted production for October is
- 30,000.
- 31,000.
- 31,500.
- 35,000.
- Julie Finn is preparing the materials purchases budget for the first quarter. The production manager has provided the following production budget information: January – 60,000 units, February – 55,000 units, March – 50,000 units. Each unit requires 5 gallons of direct materials, and Julie wants to maintain an ending inventory equal to 15% of the next month’s production needs. How many gallons will Julie budget to purchase in February?
- 271,250
- 275,000
- 282,500
- 312,500
- Which of the following is not a step in preparing the cost of goods sold budget?
- Add the budgeted direct materials, budgeted direct labor, and budgeted manufacturing overhead used in production to the beginning work in process balance.
- Subtract the budgeted ending work in process balance to determine the budgeted cost of goods manufactured.
- Add the beginning finished goods balance.
- Enter the standard cost of each product.
- The master budget process begins with the
- cash budget.
- operating budget.
- production budget.
- sales budget.
- Staci Pearce is preparing a direct labor budget. Her sales budget shows total sales units of 15,000 and sales dollars of $45,000. The direct materials purchases budget shows materials to be purchased of 25,000 units and budgeted purchases cost of $18,750. The production budget indicates a total of 25,000 units to be produced. Standard direct labor hours per unit is .50 and the standard average wage rate is $10. What is budgeted direct labor cost?
- $125,000
- $143,750
- $188,750
- $250,000
- James Worman is preparing a direct labor budget. His sales budget shows total sales units of 15,000 and sales dollars of $18,750. The direct materials purchases budget shows materials to be purchased of 15,000 units and budgeted purchases cost of $3,750. The production budget indicates a total of 12,000 units to be produced. Standard direct labor hours per unit are 0.30 and the standard average wage rate is $15. What is budgeted direct labor cost?
- $67,500
- $54,000
- $180,000
- $225,000
- Martin, Inc. is preparing a direct labor budget for the next quarter. Which of the following items will Martin not need to complete the budget?
- Actual sales
- Standard hourly labor rate
- Standard direct labor hours per unit
- Budgeted production
- Myers Company is preparing the raw materials ending inventory budget. Which of the following items will Myers not need to complete the budget?
- Beginning raw materials inventory balance
- Actual production
- Direct materials used in the production of new units started during the period
- Ending raw materials inventory balance
- Phillip Co. manufactures decorative pillows designed for use on outdoor patios. Phillip requires that 30 percent of next month’s sales be on hand at the end of each month. The following information is available regarding budgeted sales of pillows:
February | March | April | May | June | |
Budgeted unit sales | 25,000 | 22,000 | 30,000 | 44,000 | 60,000 |
What is budgeted production for April?
- 30,000
- 34,200
- 43,200
- 21,000
- Phillip Co. manufactures decorative pillows designed for use on outdoor patios. Phillip requires that 30 percent of next month’s sales be on hand at the end of each month. The following information is available regarding budgeted sales of pillows:
February | March | April | May | June | |
Budgeted unit sales | 25,000 | 22,000 | 30,000 | 44,000 | 60,000 |
What is budgeted production for May?
- 44,000
- 48,800
- 62,000
- 30,800
- Barry Co. manufactures leather briefcases and carryalls. Barry’s production manager has provided the following production budget. Each briefcase or carryall requires 1.2 yards of leather fabric and Barry maintains an ending inventory of leather fabric equal to 25% of the next month’s production needs.
February | March | April | May | June | |
Budgeted production | 50,000 | 44,000 | 60,000 | 64,000 | 58,000 |
How many yards of leather fabric will Barry budget to purchase in May?
- 94,200
- 75,000
- 62,500
- 76,800
- Barry Co. manufactures leather briefcases and carryalls. Barry’s production manager has provided the following production budget. Each briefcase or carryall requires 1.2 yards of leather fabric and Barry maintains an ending inventory of leather fabric equal to 25% of the next month’s production needs.
February | March | April | May | June | |
Budgeted production | 50,000 | 44,000 | 60,000 | 64,000 | 58,000 |
If each yard of leather fabric costs $8.60, how much should Barry budget for purchases of fabric in April?
- $784,320
- $629,520
- $619,200
- $524,600
- Barry Co. manufactures leather briefcases and carryalls. Barry’s production manager has provided the following production budget. Each briefcase or carryall requires 1.2 yards of leather fabric and Barry maintains an ending inventory of leather fabric equal to 25% of the next month’s production needs.
February | March | April | May | June | |
Budgeted production | 50,000 | 44,000 | 60,000 | 64,000 | 58,000 |
If each yard of leather fabric costs $6.40, how much should Barry budget for purchases of fabric in February?
- $468,480
- $372,480
- $310,400
- $384,000
- Percy’s Pickled Snacks produces several types of pickled vegetables. The company budgets for each quarter in the last month of the previous quarter. In early March, Percy is preparing the budget for pickled beets. Budgeted sales are 12,000 jars for April, 16,000 jars for May, and 19,000 jars for June. Each jar requires 1.2 pounds of beets. The pickling process takes 60 minutes for 20 jars. Because pressurized cooking is used, the processing is monitored by an employee at all times. Each jar of pickled beets sells for $15.00. Percy requires ending Finished Goods inventory equal to 25% of the following month’s sales. Other information is as follows:
Standard direct labor rate | $ 12.00 | per hour |
Manufacturing overhead rate | 45.00 | per direct labor hour |
Price of beets | 6.00 | per pound |
Price of jars, 100-lot | 150.00 | per lot |
What is Percy’s production budget for April?
- 12,000
- 13,000
- 16,000
- 11,000
- Percy’s Pickled Snacks produces several types of pickled vegetables. The company budgets for each quarter in the last month of the previous quarter. In early March, Percy is preparing the budget for pickled beets. Budgeted sales are 12,000 jars for April, 16,000 jars for May, and 19,000 jars for June. Each jar requires 1.2 pounds of beets. The pickling process takes 60 minutes for 20 jars. Because pressurized cooking is used, the processing is monitored by an employee at all times. Each jar of pickled beets sells for $15.00. Percy requires ending Finished Goods inventory equal to 25% of the following month’s sales. Other information is as follows:
Standard direct labor rate | $ 12.00 | per hour |
Manufacturing overhead rate | 45.00 | per direct labor hour |
Price of beets | 6.00 | per pound |
Price of jars, 100-lot | 150.00 | per lot |
What is Percy’s direct labor budget for May?
- $12,450
- $10,050
- $7,200
- $9,600
- Percy’s Pickled Snacks produces several types of pickled vegetables. The company budgets for each quarter in the last month of the previous quarter. In early March, Percy is preparing the budget for pickled beets. Budgeted sales are 12,000 jars for April, 16,000 jars for May, and 19,000 jars for June. Each jar requires 1.2 pounds of beets. The pickling process takes 60 minutes for 20 jars. Because pressurized cooking is used, the processing is monitored by an employee at all times. Each jar of pickled beets sells for $15.00. Percy requires ending Finished Goods inventory equal to 25% of the following month’s sales. Other information is as follows:
Standard direct labor rate | $ 12.00 | per hour |
Manufacturing overhead rate | 45.00 | per direct labor hour |
Price of beets | 6.00 | per pound |
Price of jars, 100-lot | 150.00 | per lot |
What is Percy’s overhead budget for April?
- $27,000
- $29,250
- $36,000
- $20,250
- Percy’s Pickled Snacks produces several types of pickled vegetables. The company budgets for each quarter in the last month of the previous quarter. In early March, Percy is preparing the budget for pickled beets. Budgeted sales are 12,000 jars for April, 16,000 jars for May, and 19,000 jars for June. Each jar requires 1.2 pounds of beets. The pickling process takes 60 minutes for 20 jars. Because pressurized cooking is used, the processing is monitored by an employee at all times. Each jar of pickled beets sells for $15.00. Percy requires ending Finished Goods inventory equal to 25% of the following month’s sales. Other information is as follows:
Standard direct labor rate | $ 12.00 | per hour |
Manufacturing overhead rate | 45.00 | per direct labor hour |
Price of beets | 6.00 | per pound |
Price of jars, 100-lot | 150.00 | per lot |
What is Percy’s cost of goods sold budget for April?
- $150,150
- $138,600
- $120,900
- $111,600
OH: $45 × 600 = $27,000; DM: 12,000 × 1.2 × $6 = $86,400; $18,000 + $7,200 + $27,000 + $86,400 = $138,600
- Which of the following items would most likely differ on the cash budget and the budgeted income statement?
- Insurance expense
- Advertising expense
- Bad debt expense
- Supplies expense
- Which of the following items would most likely differ on the cash budget and the budgeted income statement?
- Rent expense
- Research and development expense
- Sales commissions expense
- Depreciation expense
- Which of the following is not a component of the cash budget?
- Cash available to spend
- Short-term financing
- Reconciliation of beginning and ending cash
- Cash disbursements
- Which of the following is one of the major reasons that small businesses fail?
- Inadequate cash flow
- Inadequate net income
- Inadequate earnings per share
- Inadequate assets
- The basic managerial functions that help managers ensure that enough cash is available to run the business is the function of
- planning.
- controlling.
- evaluation.
- decision making.
- The plan that helps manage cash flow is the
- statement of cash flows.
- budgeted Income statement.
- cash budget.
- schedule of cash activities.
- Many new businesses fail not because they are unprofitable, but because
- they do not have the expertise to maintain the business.
- they run out of cash.
- they do not have adequate inventory.
- there is a declining demand of the products.
- Trail Industries is preparing its cash budget for the third quarter of the current year. Sales for the third quarter are budgeted at $870,000 ($290,000 per month). Sales are 80% cash, with the remaining 20% on credit which is collected in the month following the month of sale. On June 30, the cash balance is $48,000, and the Accounts Receivable (all related to June sales) balance is $51,000. Operating expenses for the quarter are budgeted at $464,000, which includes $18,000 of depreciation. Cash expenses are paid in the month incurred. Cash purchases for merchandise inventory are budgeted at $392,000 for the quarter. What is the projected cash balance at the end of the third quarter?
- $113,000
- $73,000
- $4,000
- $131,000
- Quail Industries is preparing its cash budget for the third quarter of the current year. Sales for the third quarter are budgeted at $696,000 ($232,000 per month). Sales are 80% cash, with the remaining 20% on credit which is collected in the month following the month of sale. On June 30, the cash balance is $38,400, and the Accounts Receivable (all related to June sales) balance is $40,800. Operating expenses for the quarter are budgeted at $371,200, which includes $14,400 of depreciation. Cash expenses are paid in the month incurred. Cash purchases for merchandise inventory are budgeted at $313,600 for the quarter. To prepare for the busy fourth quarter, Quail’s desired cash balance on September 30 is $120,000. How much financing will the company need at the end of the third quarter?
- $29,600
- $61,600
- $116,800
- $15,200
$120,000 ̶ $58,400 =$61,600
- Avery Manufacturing has the following sales budgets for the fourth quarter.
Cash Sales | Credit Sales | |
October | $580,400 | $232,900 |
November | 624,800 | 344,000 |
December | 806,900 | 398,700 |
The accounting manager has analyzed cash collections and determined that credit sales are collected 70% in the month of sale, 20% in the month following the sale, and 10% uncollectible. How much cash is Avery expected to collect in November?
- $865,600
- $912,180
- $787,830
- $693,600
- Avery Manufacturing has the following sales budgets for the fourth quarter.
Cash Sales | Credit Sales | |
October | $580,400 | $232,900 |
November | 624,800 | 344,000 |
December | 806,900 | 398,700 |
The accounting manager has analyzed cash collections and determined that credit sales are collected 70% in the month of sale, 20% in the month following the sale, and 10% in the second month following sale. How much cash is Avery expected to collect in December?
- $1,154,790
- $1,178,080
- $898,990
- $1,205,600
- Alexa Industries has the following amounts budgeted for selling and administrative expenses for February:
Advertising | $78,600 |
Utilities | 56,200 |
Office equipment depreciation | 14,800 |
Bad debts | 6,400 |
Entertainment | 13,200 |
What amount will Alexa report on its February cash budget for selling and administrative expenses?
- $154,400
- $148,000
- $169,200
- $156,000
- Morgan Manufacturing is preparing its cash budget for the second quarter. The inventory manager has provided the following amounts budgeted for materials purchases:
April | $62,880 |
May | 44,960 |
June | 47,360 |
The controller reports that Morgan pays for 20% of its purchases in the month of purchase, 60% in the month following purchase, and 20% in the second month after purchase. What are Morgan’s budgeted cash payments for purchases in June?
- $39,552
- $49,024
- $89,912
- $9,472
- Sophia, Inc. is preparing its cash budget for the fourth quarter. The inventory manager advises that materials purchases will be $40,000 in October and will increase by 25% for each month thereafter due to the holiday season. Sophia’s purchases in September were $32,000. Sophia pays for purchases 50% in the month after sale and 50% in the 2nd month after the sale. What are Sophia’s budgeted cash payments for purchases in November?
- $45,000
- $36,000
- $61,000
- $40,000
- If a company gets the sales forecast wrong, which of the following budgets will also be incorrect?
- Direct labor budget
- Production budget
- Budgeted income statement
- Which of the following is not a suggested source for forecasting sales?
- Customer-provided requirements
- Historical sales data
- Random statistical data
- Industry projections
- Which of the following is a suggested source for forecasting sales for a new business?
- Industry projections
- Factory capacity
- Projected production.
- Time and motion studies.
- To determine the cash payments for direct materials during a period, companies prepare a
- cash payment for materials budget.
- cash flow from operating activities.
- cash disbursements schedule.
- Which of the following does not appear in the Other Cash Disbursements section of the Cash Budget?
- Dividend payments
- Income tax payments
- Depreciation on factory equipment
- Purchase of new equipment
- A company is preparing its cash budget for the first quarter of the year. It has $1,000 in cash at the beginning of the period. Cash sales for the quarter are budgeted at $30,000. Selling and administrative expenses are budgeted at $8,000, which includes $2,000 depreciation. Cash expenses are paid in the month incurred. Cash payment for inventory purchases are budgeted at $25,000. The desired cash balance on March 31 is $5,000. How much financing will the company need during the quarter?
- $0
- $2,000
- $5,000
- $7,000
- A company is preparing its cash budget for the first quarter of the year. It has $8,000 in cash at the beginning of the period. Cash sales for the quarter are budgeted at $180,000. Selling and administrative expenses are budgeted at $58,000, which includes $12,000 depreciation. Cash expenses are paid in the month incurred. Cash payment for inventory purchases are budgeted at $135,000. The desired cash balance on March 31 is $10,000. How much financing will the company need during the quarter?
- $0
- $3,000
- $5,000
- $7,000
Finance the difference of $10,000 ̶ $7,000 = $3,000
- Johnson Equipment expects the following sales in January, February, and March:
Cash Sales | Credit Sales | |
January | $50,000 | $250,000 |
February | $45,000 | $240,000 |
March | $85,000 | $325,000 |
The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 35% in the first month after sale, and 5% in the second month after sale. How much cash will be collected from customers in March?
- $291,500
- $376,500
- $410,000
- London Manufacturing Company expects the following sales in January, February, and March:
Cash Sales | Credit Sales | |
January | $60,000 | $270,000 |
February | $50,000 | $240,000 |
March | $75,000 | $355,000 |
The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 30% in the first month after sale, 5% in the second month after sale, and 5% is expected to be uncollectible. How much cash will be collected from customers in March?
- $291,500
- $376,500
- $373,500
- $410,000
- Pepper Farm’s intern was preparing the cash budget for June. During the month, Pepper’s cash sales were $30,000 and Pepper collects 60% of credit sales during the month of sale. What was the dollar amount of Pepper’s credit sales?
Beginning cash balance | $ 3,600 |
Cash receipts | 303,600 |
Total cash available to spend | 307,200 |
Less disbursements: | |
Materials purchases | 266,100 |
Selling and administrative expenses | 54,000 |
Total cash disbursements | 320,100 |
Cash excess (needed) | (12,900) |
Borrowing | 15,900 |
Ending cash balance | $ 3,000 |
- $456,000
- $556,000
- $200,160
- $476,000
Credit sales = $456,000
Beginning cash balance | $ 1,800 |
Cash receipts | 151,800 |
Total cash available to spend | 153,600 |
Less disbursements: | |
Merchandise purchases | 133,050 |
Selling and administrative expenses | 27,000 |
Total cash disbursements | 160,050 |
Cash excess (needed) | (6,450) |
Borrowing | 7,950 |
Ending cash balance | $ 1,500 |
- $350,000
- $243,000
- $240,818
- $73,508
Purchases – Ending inventory + Beginning inventory = (Monthly sales × 55%);
$133,050 – $12,000 + $12,600 = (Monthly sales × 55%);
$133,650 ÷ 55% = Monthly sales = $243,000
- Starfish Industries’ sales budget for the first quarter of the upcoming year shows budgeted sales of $325,000, $350,000, and $310,000 in January, February, and March, respectively. All sales are made on credit. The cash receipts budget for March shows total cash receipts equal to $296,780. Starfish grants a discount to customers who pay within 10 days of the invoice. Starfish collects 60% of sales within the discount period, 20% in the month of sale but outside the discount period, 15% in the month following sale and the remainder is uncollectible. What is the discount offered by Starfish, and what are the cash collections in March associated with March sales?
- 2%; $244,280
- 1.5%; $245,210
- 2%; $182,280
- 1.5%; $183,210
$296,780 = ($310,000 × 60% x discount %) + ($310,000 × 20%) + ($350,000 × 15%);
$182,280 = ($310,000 × 60% × discount %); Discount = 2%;
March collections = ($310,000 × 60% × 98%) + ($310,000 × 20%) = $244,280
- $193,958
- $221,625
- $155,000
- $314,795
$148,390 = (March sales × 60% × 98%) + (March sales × 20%) + ($175,000 × 15%);
$122,140 = (.588 March sales) + .2 March sales;
$155,000 = March sales
- Wright’s sales budget for the third quarter of the upcoming year shows budgeted sales of $465,000, $525,000, and $487,500 in July, August, and September, respectively. All sales are made on credit. The cash receipts budget for September shows total cash receipts equal to $459,975. Wright grants a discount to customers who pay within 10 days of the invoice. Wright collects 60% of sales within the discount period, 20% in the month of sale but outside the discount period, 15% in the month following sale and the remainder is uncollectible. What is the discount offered by Wright, and what are the cash collections in September associated with September sales?
- 2%; $477,750
- 2%; $384,150
- 3%; $283,725
- 3%; $381,225
$459,975 = ($487,500 × 60% × discount %) + ($487,500 × 20%) + ($525,000 × 15%);
$283,725 = ($487,500 × 60% × discount %); Discount = 3%;
September collections = ($487,500 × 60% × 97%) + ($487,500 x 20%) = $381,225
- Pro-forma financial statements are
- based on assumed rather than actual results.
- used only in analyzing what has occurred in the past.
- based on historical data.
- not a component of the master budget.
- Starfish Industries’ sales budget for the first quarter of the upcoming year shows budgeted sales of $325,000, $350,000, and $310,000 in January, February, and March, respectively. All sales are made on credit. The cash receipts budget for March shows total cash receipts equal to $306,840. Starfish grants a discount to customers who pay within 10 days of the invoice. Starfish collects 60% of sales within the discount period, 20% in the month of sale but outside the discount period, 20% in the month following sale. What is the discount offered by Starfish, and what is the Accounts Receivable balance that will be reported in the March 31 pro-forma balance sheet?
- 6%; $73,160
- 6%; $62,000
- 4%; $70,000
- 4%; $73,160
$306,840 = ($310,000 × 60% × discount %) + ($310,000 × 20%) + ($350,000 × 20%)
$178,840 = ($310,000 × 60% × discount %); Discount = 6%
March 31 Accounts Receivable = $310,000 × 20% = $62,000
- To prepare a pro-forma income statement, information is pulled from
- the general ledger.
- the trial balance.
- components of the master budget.
- Gross profit on a pro-forma income statement is calculated as
- budgeted sales revenue minus contribution margin.
- budgeted sales revenue minus budgeted cost of goods sold.
- budgeted sales revenue minus product cost and period cost.
- On a pro-forma balance sheet, the cash balance comes directly from
- the cash receipts budget.
- the general ledger.
- the cash budget.
- the bank statement.
- On a pro-forma balance sheet, the accounts receivable balance comes directly from
- the cash receipts budget.
- the general ledger.
- the cash budget.
- the sales journal.
- Alexa Industries has the following amounts budgeted for selling and administrative expenses for February:
Advertising | $78,600 |
Rent | 56,200 |
Office equipment depreciation | 14,800 |
Bad debts | 6,400 |
Supplies | 13,200 |
What amount will Alexa report on its February pro-forma income statement for selling and administrative expenses?
- $154,400
- $169,200
- $148,000
- $156,000
- Rowen Company pays 80% of its expenses in the month incurred. Rowen’s controller has developed the following budgeted amounts budgeted for selling and administrative expenses for July:
Advertising | $16,600 |
Receptionist salary | 15,300 |
Office equipment depreciation | 8,600 |
Bad debts | 7,400 |
Supplies | 12,000 |
What amount will Rowen report on its July pro-forma income statement for selling and administrative expenses?
- $47,920
- $59,900
- $43,900
- $35,120
Answers to Multiple-Choice Questions
Item | Ans | Item | Ans | Item | Ans | Item | Ans | Item | Ans |
32 | D | 59 | D | 86 | B | 113 | D | 140 | B |
33 | A | 60 | D | 87 | B | 114 | D | 141 | B |
34 | D | 61 | B | 88 | B | 115 | A | 142 | D |
35 | C | 62 | B | 89 | B | 116 | B | 143 | C |
36 | B | 63 | D | 90 | B | 117 | A | 144 | A |
37 | B | 64 | B | 91 | A | 118 | B | 145 | A |
38 | A | 65 | A | 92 | A | 119 | B | 146 | C |
39 | A | 66 | A | 93 | B | 120 | B | 147 | C |
40 | A | 67 | B | 94 | C | 121 | B | 148 | B |
41 | B | 68 | D | 95 | D | 122 | B | 149 | B |
42 | D | 69 | D | 96 | D | 123 | B | 150 | C |
43 | C | 70 | C | 97 | B | 124 | B | 151 | A |
44 | B | 71 | B | 98 | D | 125 | B | 152 | B |
45 | D | 72 | A | 99 | C | 126 | B | 153 | A |
46 | B | 73 | C | 100 | B | 127 | B | 154 | C |
47 | A | 74 | C | 101 | B | 128 | C | 155 | D |
48 | C | 75 | A | 102 | A | 129 | D | 156 | A |
49 | B | 76 | B | 103 | D | 130 | C | 157 | B |
50 | C | 77 | B | 104 | A | 131 | A | 158 | C |
51 | A | 78 | B | 105 | C | 132 | A | 159 | B |
52 | D | 79 | C | 106 | A | 133 | C | 160 | C |
53 | C | 80 | A | 107 | A | 134 | B | 161 | A |
54 | C | 81 | B | 108 | B | 135 | B | 162 | B |
55 | D | 82 | B | 109 | D | 136 | B | 163 | B |
56 | A | 83 | B | 110 | B | 137 | B |
|
|
57 | D | 84 | B | 111 | B | 138 | B |
|
|
58 | D | 85 | B | 112 | A | 139 | B |
|
|
MATCHING
- Match the following terms to the appropriate statement by placing the letter to the left of each statement.
a. | Budgetary slack | f. | Participative budget |
b. | Cash receipts budget | g. | Practical standard |
c. | Ending inventory and cost of goods sold budget | h. | Pro-forma financial statements |
d. | Ideal standard | i. | Rolling budget |
e. | Operating budget | j. | Top-down budget |
____ |
|
____ |
|
____ |
|
____ |
|
____ |
|
____ |
|
____ |
|
____ |
|
____ |
|
____ |
|
- d – Ideal standard
- h – Pro-forma financial statements
- a – Budgetary slack
- j – Top-down budget
- e – Operating budget
- b – Cash receipts budget
- i – Rolling budget
- f – Participative budget
- c – Ending inventory and cost of goods sold budget
- g – Practical standard
BRIEF EXERCISES
- Indicate whether the following items are characteristics of imposed budgeting or participative budgeting.
Imposed | Participative | ||
a. | The most efficient method of budgeting | ||
b. | May include budgetary padding | ||
c. | Involves the fewest number of people | ||
d. | Budget process filters up through the organization | ||
e. | Tends to elicit more commitment from employees |
Imposed | Participative | ||
a. | The most efficient method of budgeting | X | |
b. | May include budgetary padding | X | |
c. | Involves the fewest number of people | X | |
d. | Budget process filters up through the organization | X | |
e. | Tends to elicit more commitment from employees | X |
- Indicate whether the following items are characteristics of imposed budgeting or participative budgeting.
Imposed | Participative | ||
a. | The least efficient method of budgeting | ||
b. | At each higher level of management, the budget is reviewed and may be altered | ||
c. | Those preparing the budget have the best understanding of the organization’s strategic direction | ||
d. | May lack commitment from employees | ||
e. | May include budgetary slack |
Imposed | Participative | ||
a. | The least efficient method of budgeting | X | |
b. | At each higher level of management, the budget is reviewed and may be altered | X | |
c. | Those preparing the budget have the best understanding of the organization’s strategic direction | X | |
d. | May lack commitment from employees | X | |
e. | May include budgetary slack | X |
- Pro-forma financial statements are prepared using the information developed in the budget process. These statements reflect the results of operations and the financial position of the organization as if all actions planned in the budget had occurred. Many of the master budget components provide direct input to the pro-forma financial statements.
Required:
For each of the following components of the financial statements, indicate which pro-forma financial statement will show the item (Income Statement or Balance Sheet) and the budget(s) within the master budget where the item originated. Number 1 provides an example.
| Financial Statement Component | Pro-forma Financial Statement | Budget(s) Where Items Originated |
1 | Revenue | Income statement | Sales budget |
2 | Selling expense |
|
|
3 | Accumulated depreciation |
|
|
4 | Bad debt expense |
|
|
5 | Short- or long-term debt |
|
|
6 | Cost of goods sold |
|
|
7 | Accrued expenses |
|
|
8 | Accounts payable |
|
|
9 | Interest expense |
|
|
10 | Raw materials inventory |
|
|
11 | Accounts receivable |
|
|
Financial Statement Component | Pro-forma Financial Statement | Budget Where Items Originated | |
1. | Revenue | Income statement | Sales budget |
2. | Selling expense | Income statement | Selling and administrative budget |
3. | Accumulated depreciation | Balance sheet | Selling and administrative budget and manufacturing overhead budget |
4. | Bad debt expense | Income statement | Cash receipts budget |
5. | Short- or long-term debt | Balance sheet | Cash budget |
6. | Cost of goods sold | Income statement | Ending inventory and cost of goods sold budget |
7. | Accrued expenses | Balance sheet | Cash budget |
8. | Accounts payable | Balance sheet | Cash payments for materials budget |
9. | Interest expense | Income statement | Cash budget |
10. | Raw materials inventory | Balance sheet | Ending inventory and cost of goods sold budget |
11. | Accounts receivable | Balance Sheet | Cash receipts budget |
- As a service to the public, the accounting department at a major university provides speakers for budgeting seminars at functions such as club meetings, couples’ retreats, and at several local half-way houses and women’s shelters. Speakers, who hold doctorate degrees in accounting, are paid by the college of business an hourly rate of $75 plus fringe benefits estimated at 30% of their hourly rate. Since all speaking engagements are in the local area, speakers are paid 10% of their hourly rate for transportation costs. Speakers are paid for their speaking time plus their travel and preparation time. The standard time estimated for each speaking engagement is 1 hour and 30 minutes.
Required:
Calculate the standard cost for each engagement.
Speaking rate per engagement ($75 × 1.5) $112.50
Fringe benefits ($112.50 × .30) 33.75
Transportation ($112.50 × .10) 11.25
Standard rate for engagement $157.50
Or
Speaking rate $75.00
Fringe benefits 22.50
Transportation 7.50
Standard rate for engagement $105.00 x 1.5 hours = $157.50
- Simple Styles is a dress manufacturer. The company purchases fabric with a list price of $200 per bolt and pays shipping charges of $3 per bolt. Each bolt contains 100 yards of fabric. Simply Styles receives a volume discount of 15% per bolt. Each dress uses a standard quantity of 2 yards of fabric.
Required:
Calculate the standard cost of material for one dress.
[$200 + $3 – ($200 × .15)] = $173 cost per bolt
$173 ÷ 100 yards = $1.73 per yard × 2 yards per dress = $3.46 standard cost per dress
- Mountaineers, Inc. makes and sells high-quality backpacking tents. Sally Gimbrel, the controller, is responsible for preparing Mountaineers’ master budget. She has received the following sales forecast for 2020 from the sales manager.
January | February | March | April | |||||
Forecasted unit sales | 2,000 | 3,500 | 4,000 | 9,500 | ||||
Sales price per unit | $100 | $100 | $100 | $100 |
Required:
Prepare Mountaineers’ sales budget for the first quarter. Omit the heading.
January | February | March | 1st Quarter | ||||
Budgeted units sold | 2,000 | 3,500 | 4,000 | 9,500 | |||
Budgeted sales price | $100 | $100 | $100 | $100 | |||
Budgeted sales revenue | $200,000 | $350,000 | $400,000 | $950,000 |
- Milligan Manufacturing Company produces and sells garden tools. The company has developed the following production plan for its new electric trimmer.
January | February | March | April | |
Budgeted production (in units) | 4,000 | 4,000 | 5,000 | 6,000 |
Each unit requires three feet of metal tubing. The company wishes to have ending inventory of metal tubing equal to 110% of its next month’s production needs, plus an additional 100 feet. January’s beginning inventory meets this requirement. Milligan’s standard cost per foot is $2.80.
Required
Prepare the 1st quarter direct materials purchases budget for metal tubing.
Milligan Manufacturing Company Direct Materials Purchases Budget – Metal Tubing 1st Quarter | ||||||||
January | February | March | 1st Quarter | |||||
Budgeted production | 4,000 | 4,000 | 5,000 | 13,000 | ||||
Standard material per unit | 3 | 3 | 3 | 3 | ||||
Production needs | 12,000 | 12,000 | 15,000 | 39,000 | ||||
Budgeted ending inventory | 13,300 | 16,600 | 19,900 | 19,900 | ||||
Total materials required | 25,300 | 28,600 | 34,900 | 58,900 | ||||
Less beginning inventory | (13,300) | (13,300) | (16,600) | (13,300) | ||||
Budgeted materials purchases | 12,000 | 15,300 | 18,300 | 45,600 | ||||
Standard price per foot | $2.80 | $2.80 | $2.80 | $2.80 | ||||
$33,600 | $42,840 | $51,240 | $127,680 |
- Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data:
January cash sales | $ 50,000 |
January credit Sales | 380,000 |
Collections from December credit sales | 150,000 |
Selling and administrative costs (paid in month of purchase) | 50,000 |
Depreciation expense | 25,000 |
Merchandise Inventory, January 1 | 200,000 |
Merchandise Inventory, January 31 | 210,000 |
Cost of goods sold is 40% of Cooper’s selling price | |
All purchases are paid in cash | |
Credit sales are collected 60% in the month of sale, 35% in the following month, and 5% is deemed uncollectible |
Required:
What is Cooper’s budgeted cash receipts for January?
Cash sales | $ 50,000 |
Credit sales collection ($380,000 x 60%) | 228,000 |
Collections from December credit sales | 150,000 |
Total January collections | $428,000 |
- Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data:
January cash sales | $ 50,000 |
January credit Sales | 380,000 |
Collections from December credit sales | 150,000 |
Selling and administrative costs (paid in month of purchase) | 50,000 |
Depreciation expense | 25,000 |
Merchandise Inventory, January 1 | 200,000 |
Merchandise Inventory, January 31 | 210,000 |
Cost of goods sold is 40% of Cooper’s selling price. | |
All purchases are paid in cash. | |
Credit sales are collected 60% in the month of sale, 35% in the following month, and 5% is deemed uncollectible. |
Required:
What is Cooper’s budgeted cash disbursements for January?
Selling and administrative costs | $ 50,000 |
Purchases $210,000 + [($50,000 + $380,000) × .40] – $200,000 | 182,000 |
Total January disbursements | $232,000 |
- Richardson Company has provided you with the following numbers pulled from various budgets related to January 2020 activity:
Beginning cash balance from cash budget | $ 12,000 |
Sales revenue from sales budget | 300,000 |
Cost of goods sold from cost of goods sold budget | 180,000 |
Selling and administrative expenses from selling and administrative expense budget (includes depreciation expense of $5,000) | 50,000 |
Interest expense from cash budget | 8,000 |
Required:
Prepare a pro-forma income statement for Richardson Company
Richardson Company Pro-Forma Income Statement For the Month Ending January 31, 2020 | |
Revenue | $300,000 |
Cost of goods sold | 180,000 |
Gross profit | 120,000 |
Selling and administrative expenses | 50,000 |
Operating income | 70,000 |
Interest expense | 8,000 |
Operating income | $ 62,000 |
EXERCISES
- Danny’s Delights is a wholesale bakery. Danny makes a variety of baked goods which he sells to restaurants and grocery stores. His best-selling item is a peanut butter cookie. The recipe calls for 1 cup of peanut butter, 1 cup of sugar and 1 egg. Each recipe makes a batch of one dozen cookies. Danny’s standard direct materials cost for batch of cookies is $0.90 for peanut butter, $0.15 for sugar and $0.10 for an egg. In addition, the cookies are packaged by the dozen in cardboard containers costing $0.25 each. One batch of cookies requires 4 minutes preparation time, 8 minutes of cooking time, and 3 minutes of packaging time. The standard wage rate is $15 per hour. Overhead is applied at 50% of direct labor cost.
Required:
Calculate the standard cost for a batch (1 dozen) of peanut butter cookies.
Direct material ($0.90 + $0.15 + $0.10 + $0.25) $1.40
Direct labor ($15 × [(4 + 8 + 3) ÷ 60] 3.75
Manufacturing overhead ($3.75 × .50) 1.88
Standard cost for a dozen cookies $7.03
- Candi’s Wholesale Foods specializes in providing hors d'oeuvres at a wholesale price to caterers. One of Candi’s best sellers is a fruit éclair. Her recipe calls for 1 pint of pastry cream, 8 ladyfinger cookies, and 2 cups of fruit (strawberries, raspberries, or blueberries). Each recipe makes 8 éclairs (one batch). The standard direct materials cost is $0.80 per pint of pastry cream, $0.90 for a box of 24 ladyfingers, and $0.25 for a cup of fruit. The éclairs are packed on plastic trays costing $0.30 each. Caterers pick up the éclairs immediately so there is no storage or delivery cost to Candi. It requires one person 4 minutes preparation time and 2 minutes of packaging time for one batch of éclairs. The standard wage rate is $15 per hour. Overhead is applied at 50% of direct labor cost.
Required:
Calculate the standard cost for a batch (8 éclairs).
Direct material [$0.80 + ($0.90 ÷ 3) + (($0.25 × 2) + $0.30)] $1.90
Direct labor ($15 × [(4 + 2) ÷ 60] 1.50
Manufacturing overhead ($1.50 × .50) 0.75
Standard cost per batch $4.15
- Custom Design manufactures t-shirts for new parents and grandparents by turning a client’s newborn baby’s picture into a design on the shirt. The following information has been provided by various units within Custom Design’s departments. The company purchases cotton t-shirts in bundles of 100 at a price of $400 per bundle. Custom Design has to pay shipping charges of $10 per bundle. The process of transferring pictures onto the shirts costs $0.75 per shirt. Each shirt is boxed in a cardboard box that costs $0.15 each. It takes one worker 10 minutes to prepare a shirt and transfer the picture onto the shirt and another worker 5 minutes to check the shirt for flaws in the printing and package the shirt. Workers are paid $15 per hour. Custom Design applies overhead at a rate of 100% of direct labor cost.
Required:
Compute the standard cost of producing one t-shirt.
Material
Purchase price ($400 ÷ 100) $ 4.00
Shipping ($10 ÷ 100) 0.10
Packaging 0.15
Picture transfer 0.75
Labor: $15 × ¼ hour 3.75
Overhead: $3.75 × 100% 3.75
Total standard cost per shirt $12.50
- Custom Design manufactures baby blankets by turning a client’s photograph of a new baby into a design printed on the blanket. This is a popular item, selling for $30, for new parents and grandparents. The following information has been provided by various units within Custom Design’s departments. The company purchases fleece blankets in bundles of 100 at a price of $500 per bundle. Custom Design has to pay shipping charges of $10 per bundle. The process of transferring a picture onto a blanket costs $1.50. Each blanket is boxed in a cardboard box that costs $0.25 each. It takes one worker 15 minutes to prepare a blanket and transfer the picture onto the blanket and another worker 5 minutes to check the blanket for flaws in the printing and package the blanket. Workers are paid $15 per hour. Custom Design applies overhead at a rate of 120% of direct labor cost.
Required
Compute the standard cost of producing one blanket.
Material
Purchase price ($500 ÷ 100) $ 5.00
Picture transfer 1.50
Shipping ($10 ÷ 100) 0.10
Packaging 0.25
Labor
$15 × [(15 + 5) ÷ 60] hours 5.00
Overhead
$5 × 120% 6.00
Total standard cost per shirt $17.85
- Murphy Company produces and sells only one product, heavy-duty cargo carriers for trucks. The company is preparing its selling and administrative expense budget for the month. The following information has been provided to assist in the budgeting process.
Variable Cost Per Unit Sold | Monthly Fixed Cost | |||
Sales commissions | $0.50 | |||
Shipping | 5.00 | |||
Advertising | 1.25 | $ 10,000 | ||
Executive salaries | 150,000 | |||
Depreciation on office equipment | 10,000 | |||
Other | 0.30 | 15,000 |
All cash expenses are paid in the month they are incurred.
Required:
Murphy has budgeted to sell 5,000 units during July. Prepare the selling and administrative expense budget for July.
Murphy Company Selling and Administrative Expense Budget | ||
Selling expenses | ||
Sales commission (5,000 × $0.50) | $ 2,500 | |
Shipping (5,000 × $5) | 25,000 | |
Advertising [(5,000 × $1.25) + $10,000] | 16,250 | $ 43,750 |
Administrative expenses | ||
Executive salaries | $150,000 | |
Depreciation on office equipment | 10,000 | |
Other [(5,000 × $0.30) + $15,000 | 16,500 | 176,500 |
Total selling and administrative expense | $220,250 |
- Berry Products Company manufactures and sells a single product. Each unit requires three feet of tubing. Berry’s budgeted production is as follows:
December 15,000 units
January 14,000 units
February 15,000 units
March 12,000 units
April 13,000 units
Berry budgets monthly ending inventories to be equal to 20% of the following month’s production needs. The January beginning inventory meets this requirement. The tubing costs $0.80 per foot.
Required:
Prepare the direct material purchases budget for tubing for the first quarter.
Berry Products Company Direct Materials Purchases Budget | ||||
January | February | March | 1st Quarter | |
Budgeted production | 14,000 | 15,000 | 12,000 | 41,000 |
Standard materials per unit (feet) | 3 | 3 | 3 | 3 |
Production needs (feet) | 42,000 | 45,000 | 36,000 | 123,000 |
Budgeted ending Inventory | 9,000 | 7,200 | 7,800 | 7,800 |
Total materials required (feet) | 51,000 | 52,200 | 43,800 | 130,800 |
Beginning inventory (feet) | 8,400 | 9,000 | 7,200 | 8,400 |
Budgeted materials purchases (feet) | 42,600 | 43,200 | 36,600 | 122,400 |
Standard price per foot | $ 0.80 | $ 0.80 | $ 0.80 | $ 0.80 |
Budgeted purchases cost | $34,080 | $34,560 | $29,280 | $97,920 |
- Grantham Manufacturing Company makes oak rocking chairs. Budgeted sales are 20,000 for July, 25,000 for August, 28,000 for September and 30,000 for October. Grantham maintains an ending inventory equal to 10% of the current month’s sales. Ending inventory at June 30th was 3,000.
Required:
Prepare a production budget for the 3rd quarter ending September 30.
Grantham Manufacturing Company Production Budget | ||||
July | August | September | 3rd Quarter | |
Budgeted sales | 20,000 | 25,000 | 28,000 | 73,000 |
Budgeted ending inventory | 2,000 | 2,500 | 2,800 | 2,800 |
Total units required | 22,000 | 27,500 | 30,800 | 75,800 |
Beginning inventory | 3,000 | 2,000 | 2,500 | 3,000 |
Budgeted production | 19,000 | 25,500 | 28,300 | 72,800 |
- Brand, Inc. makes portable generators. Budgeted sales are 20,000 for July, 25,000 for August, 28,000 for September, and 31,000 for October. Brand maintains an ending inventory equal to 10% of the following month’s sales. Ending inventory at June 30th was 2,000.
Required
Prepare a production budget for the 3rd quarter ending September 30.
Brand, Inc. Production Budget | ||||
July | August | September | 3rd Quarter | |
Budgeted sales | 20,000 | 25,000 | 28,000 | 73,000 |
Budgeted ending inventory | 2,500 | 2,800 | 3,100 | 3,100 |
Total units required | 22,500 | 27,800 | 31,100 | 76,100 |
Beginning inventory | 2,000 | 2,500 | 2,800 | 2,000 |
Budgeted production | 20,500 | 25,300 | 28,300 | 74,100 |
- Haygood, Inc. is a manufacturer of cast iron fire pits. Budgeted production is 20,000 units for January and 18,000 for February and 15,000 for March. The manufacturing process is highly automated but requires ¼ hour of direct labor time for each unit. The standard wage rate is $10.
Required:
Prepare a direct labor budget for the first quarter.
Haygood, Inc. Direct Labor Budget | |||||
January | February | March | 1st Quarter | ||
Budgeted production | 20,000 | 18,000 | 15,000 | 53,000 | |
Standard direct labor hours per unit | .25 | .25 | .25 | .25 | |
Total direct labor hours required | 5,000 | 4,500 | 3,750 | 13,250 | |
Standard average wage rate | $10 | $10 | $10 | $10 | |
Budgeted direct labor cost | $50,000 | $45,000 | $37,500 | $132,500 |
- Outfitters, Inc. is a manufacturer of ultra-light sleeping bags. Budgeted production is 20,000 units for January and 18,000 for February and 15,000 for March. Each sleeping bag requires two hours of direct labor. The standard wage rate is $15.
Required:
Prepare a direct labor budget for the first quarter.
Outfitters, Inc. Direct Labor Budget | ||||
January | February | March | 1st Quarter | |
Budgeted production | 20,000 | 18,000 | 15,000 | 53,000 |
Standard direct labor hours per unit | 2 | 2 | 2 | 2 |
Total direct labor hours required | 40,000 | 36,000 | 30,000 | 106,000 |
Standard average wage rate | $15 | $15 | $15 | $15 |
Budgeted direct labor cost | $600,000 | $540,000 | $450,000 | $1,590,000 |
- Greenland, Inc. is a manufacturing company specializing in eco-friendly products. The company has recently developed a new water filter. Because the product is new to the market, Greenland does not have a prior history of sales to help develop its budget for the coming quarter. Greenland has agreements from several retail outlets to promote and stock the filters. Based on customers’ request and Greenland’s sales staff, managers have estimated January sales to be 200 units and estimate that sales will double each month for the next six months. Units are priced at $120 each.
Required:
Prepare a sales budget for the first quarter.
Greenland, Inc. Sales Budget | |||||
January | February | March | 1st Quarter | ||
Budgeted sales units | 200 | 400 | 800 | 1,400 | |
Budgeted sales price | $ 120 | $ 120 | $ 120 | $ 120 | |
Budgeted sales revenue | $24,000 | $48,000 | $96,000 | $168,000 |
- Williams Company makes and sells laundry duffel bags. Each duffel bag sells for $20 and has a unit variable cost of $12. The company has provided the following budgeting data for March:
Sales (all cash sales) | $34,000 |
Cash balance on March 1 | 4,000 |
Cash disbursements during the month | 36,000 |
A minimum cash balance on March 31 | 4,000 |
If necessary, Williams will borrow cash from the local bank in multiples of $1,000.
Required:
- How many units did Williams budget to sell during March?
- What is Williams’ budgeted cash balance at the end of the period before borrowing?
- How much should Williams budget for borrowing in January?
- $34,000 ÷ $20 = 1,700 units
- Beginning cash balance $ 4,000
Cash collections 34,000
Cash disbursements 36,000
Cash balance March 31 $ 2,000
- Williams must borrow $2,000 to maintain a $4,000 minimum cash balance
- Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data:
Cash sales | $ 25,000 | ||
Credit sales (60% collected in month of sale) | 380,000 | ||
Selling and administrative costs (including depreciation) | 50,000 | ||
Depreciation expense | 5,000 | ||
Merchandise Inventory, January 1 | 21,000 | ||
Merchandise Inventory, January 31 | 20,000 | ||
Beginning cash balance | 3,000 | ||
Minimum cash balance required | 2,500 | ||
Cost of goods sold is 55% of Cooper’s selling price. | |||
All purchases are paid in cash. | |||
Selling and administrative costs are paid in month of purchase. |
Required:
Prepare a cash budget for January. Omit the heading.
Beginning cash balance | $ 3,000 |
Cash receipts $25,000 + ($380,000 x .60) | 253,000 |
Total cash available to spend | 256,000 |
Less Disbursements: | |
Materials purchases $21,000 ̶ $20,000 ̶ (55% × [25,000 + $380,000)] | 221,750 |
Selling and administrative expenses | 45,000 |
Total cash disbursements | 266,750 |
Cash excess (needed) | (10,750) |
Borrowing | 13,250 |
Ending cash balance | $ 2,500 |
PROBLEMS
188. Go-Spa Enterprises is a portable hot tub manufacturer. The company produces both 2-person and 4-person hot tubs. John Ireland, the company’s sales manager, prepared the following sales forecast for 2021. The forecasted sales prices include a 5 percent increase in the 2-person spa price and a 10 percent increase in the 4-person spa price, to cover anticipated increases in raw materials prices.
Units | |||||
Sales Price | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
2-person spa | $1,250 | 500 | 500 | 400 | 600 |
4-person spa | $2,600 | 200 | 100 | 100 | 200 |
Required:
a. Prepare Go-Spa’s sales budget for 2021. Omit the heading.
b. On December 31, 2020, Go-Spa had 80 2-person spas in stock—fewer than the desired inventory level of 100, based on the following quarter’s sales. The company has budgeted for sales of 450 2-person spas in the first quarter of 2022. Prepare the 2021 production budget for 2-person spas. Omit the heading.
c. Each 2-person spa requires a pump motor, which Go-Spa purchases for $160. On December 31, 2020, Go Spa had 400 pump motors in inventory. Damage during the installation process results in a standard quantity of 1.2 motors per spa. Because of recent delivery problems, Go-Spa wants to maintain an ending inventory equal to 50 percent of the following quarter’s production needs. Since the supplier has assured Go-Spa that the delivery issues will be resolved by the end of December, Go-Spa wants only 300 motors in inventory on December 31, 2021. Prepare the purchases budget for motors for 2021.
a.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual
2-person spas:
Budgeted unit sales 500 500 400 600 2,000
Budgeted sales price × $ 1,250 × $ 1,250 × $ 1,250 × $ 1,250 × $ 1,250
Budgeted revenue $625,000 $625,000 $500,000 $750,000 $2,500,000
4-person spas:
Budgeted units sales 200 100 100 200 600
Budgeted sales price × $ 2,600 × $ 2,600 × $ 2,600 × $ 2,600 × $ 2,600
Budgeted revenue $520,000 $260,000 $260,000 $520,000 $1,560,000
Total revenue $1,145,000 $885,000 $760,000 $1,270,000 $4,060,000
b.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual
Budgeted unit sales 500 500 400 600 2,000
+ Budgeted ending inventory 100 80 120 90 90
= Total units required 600 580 520 690 2,090
− Beginning inventory 80 100 80 120 80
= Budgeted production 520 480 440 570 2,010
c.
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual
Budgeted production 520 480 440 570 2,010
× Standard pump motors per spa × 1.2 × 1.2 × 1.2 × 1.2 × 1.2
= Production needs 624 576 528 684 2,412
+ Budgeted ending inventory 288 264 342 300 300
= Total DM required (motors) 912 840 870 984 2,712
− Beginning inventory 400 288 264 342 400
= Budgeted purchases (motors) 512 552 606 642 2,312
× Standard price per motor × $160 × $160 × $160 × $160 × $160
= Budgeted purchases cost $81,920 $88,320 $96,960 $102,720 $369,920
189. Senegalese Specialties, a retailer of West African food products, has completed the following sales forecast for the coming year:
January $37,000 July $38,000
February 38,000 August 37,000
March 32,000 September 33,000
April 40,000 October 40,000
May 36,000 November 48,000
June 31,000 December 52,000
Senegalese Specialties maintains an ending inventory level of 60 percent of the following month’s cost of goods sold. The company’s cost of goods sold is 35 percent of sales.
Required:
a. Prepare Senegalese Specialties purchases budget for June and July. Omit the heading. Use the following format:
Budgeted sales dollars
× Cost of goods sold percentage
= Cost of goods sold
+ Ending inventory
= Total inventory required
− Beginning inventory
= Budgeted purchases
b. Assuming that Senegalese Specialties pays for 50 percent of its purchases in the month of purchase and the remaining 50 percent in the month following the purchase, prepare the company’s cash payments budget for July. Omit the heading.
a.
June July August
Budgeted sales $31,000 $38,000 $37,000
× COGS percentage × .35 × .35 × .35
= Cost of goods sold 10,850 13,300 12,950
+ Budgeted ending inventory 7,980 7,770
= Total inventory required 18,830 21,070
− Beginning inventory 6,510 7,980
= Budgeted purchases $12,320 $13,090
b. 50% of June purchases: $12,320 × .5 = $6,160
50% of July purchases: $13,090 × .5 = 6,545
$12,705
190. Garden Gnomes Company produces various types of lawn ornaments. The company’s sales budget for the first four months of the coming year is as follows. All sales are made on credit.
March April May June
Budgeted sales $550,000 $650,000 $700,000 $620,000
Garden Gnomes is planning to change its credit policies in the coming year. For the first time in its history, the company is offering a 2 percent discount to customers who pay within 15 days of the invoice date. Based on industry trends, Garden Gnomes estimates that this change will result in 60 percent of credit sales being paid within the discount period; another 20 percent of sales, within the month of sale (but outside of the discount period); and another 15 percent of sales, during the month after the sale. An estimated 5 percent of sales will be uncollectible.
Required:
a. Prepare Garden Gnomes’ cash receipts budget for the second quarter of the coming year. Omit the heading.
b. How much cash will Garden Gnomes sacrifice in the second quarter by offering the new discount?
c. What do you think led Garden Gnomes to offer the new discount to customers?
Total Cash Bad Accounts
a. April May June Receipts Debts Receivable
March sales
$550,000 × 15% $ 82,500 $82,500
April sales
$650,000 × 60% × 98% 382,200 382,200
$650,000 × 20% 130,000 130,000
$650,000 × 15% $ 97,500 97,500
$650,000 × 5% $32,500
May sales
$700,000 × 60% × 98% 411,600 411,600
$700,000 × 20% 140,000 140,000
$700,000 × 15% $105,000 105,000
$700,000 × 5% 35,000
June sales
$620,000 × 60% × 98% 364,560 364,560
$620,000 × 20% 124,000 124,000
$620,000 × 15%
$620,000 × 5% 31,000 $93,000
Totals $594,700 $649,100 $593,560 $1,837,360 $98,500 $93,000
b. April: $650,000 × 60% × 2% = $ 7,800
May: $700,000 × 60% × 2% = 8,400
June: $620,000 × 60% × 2% = 7,440
$23,640
c. Garden Gnomes may have offered the discount to customers because competitors were doing the same thing, or it could be that the company needed to accelerate its cash flows to be able to pay its bills on time.
191. Sedona Gear Company, a rapidly growing distributor of camping equipment, is formulating its plans for the coming year. Cody Mosbay, the firm’s marketing director, has completed the following sales forecast.
Month | Sales | Month | Sales | |
January | $ 900,000 | July | $1,900,000 | |
February | 1,000,000 | August | 1,900,000 | |
March | 900,000 | September | 1,600,000 | |
April | 1,200,000 | October | 1,600,000 | |
May | 1,500,000 | November | 1,800,000 | |
June | 1,900,000 | December | 2,000,000 |
Patti Bodkin, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. She has gathered the following information.
- All sales are made on credit.
- Sedona’s excellent record in accounts receivable collection is expected to continue, with 65 percent of billings collected in the month after sale and the remaining 35 percent collected in the second month after the sale.
- Cost of goods sold, Sedona’s largest expense, is estimated to equal 45 percent of sales dollars. Seventy percent of inventory is purchased one month prior to sale and 30 percent during the month of sale. For example, in April, 30 percent of April cost of goods sold is purchased and 70 percent of May cost of goods sold is purchased.
- All purchases are made on account. Historically, 70 percent of accounts payable have been paid during the month of purchase, and the remaining 30 percent in the month following purchase.
Required:
a. Prepare the cash receipts budget for the second quarter. Omit the heading.
b. Prepare the purchases budget for the second quarter. Omit the heading.
c. Prepare the cash payments budget for the second quarter. Omit the heading.
a. Total Cash Accounts
April May June Receipts Receivable
February sales
$1,000,000 × 35% $350,000 $350,000
March sales
$900,000 × 65% 585,000 585,000
$900,000 × 35% $315,000 315,000
April sales
$1,200,000 × 65% 780,000 780,000
$1,200,000 × 35% $ 420,000 420,000
May sales
$1,500,000 × 65% 975,000 975,000
$1,500,000 × 35% $525,000
Totals $935,000 $1,095,000 $1,395,000 $3,425,000 $525,000
b. Total
April May June Purchases
April COGS
$1,200,000 × 45% × 30% $162,000 $162,000
May COGS
$1,500,000 × 45% × 70% 472,500 472,500
$1,500,000 × 45% × 30% $202,500 202,500
June COGS
$1,900,000 × 45% × 70% 598,500 598,500
$1,900,000 × 45% × 30% $256,500 256,500
July COGS
$1,900,000 × 45% × 70% 598,500 598,500
Totals $634,500 $801,000 $855,000 $2,290,500
c. Total Cash Accounts
April May June Payments Payable
March purchases
$499,500a × 30% $149,850 $149,850
April purchases
$634,500 × 70% 444,150 444,150
$634,500 × 30% $190,350 190,350
May purchases
$801,000 × 70% 560,700 560,700
$801,000 × 30% $240,300 240,300
June purchases
$855,000 × 70% 598,500 598,500
$855,000 × 30% $256,500
Totals $594,000 $751,050 $838,800 $2,183,850 $256,500
a30% of March COGS + 70% of April COGS = ($900,000 × 45% × 30%) + ($1,200,000 × 45% × 70%)
- What is budgetary slack and why is it an issue in budget preparation?
Budgetary slack, or budgetary padding, is a common problem in a bottom-up budget environment. Budgetary slack is created when managers budget a lower level of revenue or a higher level of costs than is really expected to occur. At the end of the year, the manager will “beat the budget” and look as if the manager did a great job managing her department.
Budgetary slack may appear to be harmless, but there are real consequences to the organization. Resources may not be allocated in the optimal way. Managers may receive bonuses based on their beating a padded budget, so they receive additional compensation that they would not have earned had the budget been prepared realistically.
- You have recently accepted a position as a manager with Athletic Academy. At a recent managers meeting, the controller asked for input on how to make the budgeting process more effective. Specifically, the controller indicated that the employees did not seem to be committed to the budget during the previous period. Unfortunately, none of the managers reached their targeted sales projections for the previous period.
Required:
Explain to the other managers what method the company apparently used in the previous period and why the method created the lack of commitment. Also discuss flaws if the alternative approach to budgeting is used.
The two methods are the top-down approach (imposed budget) and the bottom-up approach (participative budgeting). The top-down approach was apparently used in the previous period. It is the most efficient, because it involves the fewest number of people. In the top-down environment, employees may not be committed to the budget because executive management creates the budget and it is pushed down through the organization. However, upper management has the best understanding of the organization’s strategic direction and how to allocate resources to achieve the organization’s goals. The alternative approach is the bottom-up approach where the budgeting process begins at lower levels of manager and is reviewed as it moves up through management at each higher level. The primary behavioral issue with the bottom-up approach is that managers may pad the budget or include budgetary slack. Managers may budget lower revenues in order to meet goals or include a higher level of costs than they actually expect to incur. This may lead to managers receiving bonuses because they meet goals of a budget that is not realistic.
- On October 31, 2020, Janie Mounce, manager of a department in the largest division of the XYZ Company, was contacted by the chairman of the budget committee. Janie needed to send her 2021 departmental budget to the committee. Instructions from the chair of the committee to all the department managers indicated that any revenue or expense items that deviated more than 5% from last year’s budget needed a written explanation to be turned in with the budget.
Required:
Describe XYZ’s budget process as a top-down or bottom-up approach. What are the advantages and disadvantages of this budget process?
This process is a bottom-up approach. The process begins with managers developing and submitting their budgets rather than having executives create the budget and push it down through the organization. This budget process is also referred to as participative budgeting. Advantages of the bottom-up approach are that it is more accurate and there is greater employee commitment to the budget. Disadvantages include the issues that it is more time consuming and there is a potential for budgetary slack.
- Assume your friend is watching you prepare the master budget as part of your accounting homework. She notices that the sales budget affects both the budgeted income statement and the cash budget, but not by the same amount. Explain why the effect is not the same on the two budgets.
The effect is not the same because of a timing difference. A sale is recorded in the period when the performance obligation is satisfied, but the cash collected from the sale may be in a later period. The budgeted sales revenue from the sales budget goes directly to the budgeted income statement. The journal entry would be to debit accounts receivable and credit revenue. However, many sales transactions will result in credit sales where the collection does not occur until a month or more after the sale is made. At that time, cash would be debited and accounts receivable would be credited. The budgeted income statement uses the accrual basis of accounting where revenue is recorded when the performance obligation is satisfied (not when cash is received). On the other hand, the cash budget includes cash collections for the period from cash sales and credit sales. Some of the collections from credit sales will be from sales made in previous periods.
- What are two tradeoffs between ideal standards and practical standards that a student might be willing to accept for a Principles of Accounting class?
Some possible answers may be:
- A student might be willing to forgo an ideal standard of receiving an A in order to spend more time studying other courses.
- A student might be willing to accept an easy professor in lieu of the ideal standard of the best professor.
- A student might be willing to forgo homework points in order to attend a frat party.
- Describe the components of the cash budget and discuss why the cash budget is important to managers.
The cash budget has five major components: cash available to spend, cash disbursements, cash excess or cash needed, short-term financing, and ending cash balance. The cash budget is important to managers for several reasons. Managing cash is a common problem for individuals and organizations. The cash budget helps managers manage cash flow. Inadequate cash flow is a major reason why small businesses fail. The cash budget helps managers in all four areas of managerial functions: planning, control, evaluation, and decision making.
- The standard price of a product is comprised of several components including cost and quantity.
Required:
List the six components and explain what each includes.
Price standards are the expected cost of obtaining each input used in producing a product:
- The direct materials price standard includes the cost of getting the materials to the factory (purchase price, freight, storage, and net of discounts).
- The direct labor price standard includes wages, fringe benefits, and payroll taxes.
- The manufacturing overhead price standard is the predetermined overhead rate.
Quantity standards are the expected amount of inputs required to produce one good unit of output.
- The direct materials quantity standard is the quantity of direct materials needed to produce one unit of good output, including allowances for waste and spoilage.
- The direct labor quantity standard is the amount of direct labor time required to produce one good unit of output, including rest time and machine downtime.
- The manufacturing overhead quantity standard is based on usage of the overhead application base.
ESSAY
- The two common approaches to budgeting are the top-down budget approach and the bottom-up approach. Both methods have advantages and disadvantages both from a practical standpoint and behavioral issues. List two advantages related to each method and two disadvantages that create problems with each approach.
Top-Down Approach
Advantages
- It is the most efficient method of budget preparation.
- Upper management has the best understanding of the organization’s strategic direction and how to allocate resources to achieve the organization’s goals.
Disadvantages
- Since employees do not have input into its creation, they are not as committed to it as under a bottom-up approach.
- Managers might argue that a budget is unreasonable or unfair if they are not involved in preparing it.
Bottom-Up Approach
Advantages
- It is more accurate since those who know the most about the resources needed to operate are involved in its preparation.
- The budget is reviewed at all stages of management.
- It elicits more commitment since all levels of employees are involved in its creation.
Disadvantages
- Allocation of resources may not be done in the optimal way if managers pad the budget.
- If managers receive bonuses based on an incorrect budget, they would receive additional compensation they have not earned.
- This approach is time consuming.
- Most organizations have a plan for success. The plan may be formal or informal, but leaders should be able to identify what they want their organizations to achieve. One type of tactical planning is the budgeting process.
Required:
Describe the budget development process and explain how it fits into management’s planning process.
Budgets can be completed in either a top-down, imposed process, or a bottom-up, participative process. Either way, the process is iterative, as information is passed throughout the organization and updated for changes in planned activity. Budgets can be prepared using the prior year’s budget as a starting point, or they can be prepared using zero-based budgeting, in which each item must be justified anew each year. A budget may be prepared to cover a monthly, quarterly or annual time frame.
Executive management sets out a strategy to guide a company’s actions. The budgeting process translates that strategy into action by allocating financial resources across the organization, to ensure that the necessary steps can be taken. The budget also communicates decisions about resource allocation throughout the organization, allowing managers to plan for the future in order to mitigate potential operational risks, such as cash shortages.
- Assume you have just been hired by a large manufacturing company and have been assigned to a team that has the responsibility of gathering the data for completing the company’s operating budget. Your first assignment is to make the initial contact with the department managers who will be providing data to ensure that everyone involved knows the importance of preparing a realistic budget. The first manager you approach does not appear to know what an operating budget is and apparently is not interested in assisting your team in preparing a meaningful budget. Prepare a written memo to the managers explaining what the operating budget is, its components, and its importance.
Date
To: Department Managers
From: Your name, budget team member
During the next few days someone from the budget team will be contacting you for information concerning the next period’s budget. The team will be collecting data from you and incorporating it into the operating budget.
The operating budget provides a plan for operations during the budget period. Development of the operating budget begins with the sales budget. From those sales estimates, budgeted production, direct materials, direct labor, manufacturing overhead, and selling and administrative costs are determined. The operating budget will become a vital component of the master budget.
We will be respectful of your schedule as we go through this process. Before we meet with each of you, written guidelines will be provided to you explaining the information we will need from your department. Preparing a realistic budget will assist managers in planning for the future, reducing the need for unprepared responses to unexpected situations, and help departments communicate within our company. It will also help managers in planning, controlling, evaluating, and decision making in their respective areas.
Thank you for your participation in this process. The budget team looks forward to working with you in this endeavor.
Required:
- What is a master budget?
- What are the component parts of the master budget?
- How are the components related?
- The master budget is a collection of smaller budgets that leads to pro-forma (budgeted) financial statements.
- The first component of the master budget is the operating budget which consists of the sales budget, production budget, direct materials purchases budget, direct labor budget, manufacturing overhead budget, and selling and administrative expense budget. In addition, the master budget contains the ending inventory and cost of goods sold budget, the cash budget, budgeted income statement and budgeted balance sheet.
- Each of the budgets impacts the company’s cash position, income statement, and balance sheet. The sales budget is the key to the entire master budgeting process, since most other master budget components depend on the level of sales. The pro-forma income statement and balance sheet are prepared from numbers contained in the various components of the other budgets.
Document Information
Connected Book
Test Bank | Managerial Accounting 4th Edition by Davis Davis
By Davis Davis
Explore recommendations drawn directly from what you're reading
Chapter 3 Cost-Volume-Profit Analysis And Pricing Decisions
DOCX Ch. 3
Chapter 4 Product Costs And Job Order Costing
DOCX Ch. 4
Chapter 5 Planning And Forecasting
DOCX Ch. 5 Current
Chapter 6 Performance Evaluation Variance Analysis
DOCX Ch. 6
Chapter 7 Activity-Based Costing And Activity Based Management
DOCX Ch. 7