/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 22 Sales and production budget. The... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Sales and production budget. The Coby Company expects sales in 2018 of 201,000 units of serving trays. Coby's beginning inventory for 2018 is 13,000 trays, and its target ending inventory is 29,000 trays. Compute the number of trays budgeted for production in 2018 .

Short Answer

Expert verified
Coby Company needs to produce 217,000 serving trays in 2018 to meet its sales expectations and reach its target ending inventory. This is calculated by using the formula: Number of trays budgeted for production = Expected sales + Target ending inventory - Beginning inventory, which, in this case, is \(201,000 + 29,000 - 13,000 = 217,000\) trays.

Step by step solution

01

Identify the given information

We are given the following information: - Expected sales in 2018: 201,000 units - Beginning inventory in 2018: 13,000 trays - Target ending inventory: 29,000 trays
02

Set up the formula

Now, we need to use the formula mentioned in the Analysis section to calculate Coby Company's budgeted production for 2018: Number of trays budgeted for production = Expected sales + Target ending inventory - Beginning inventory
03

Plug the given values into the formula

Insert the given values into the formula: Number of trays budgeted for production = 201,000 trays (expected sales) + 29,000 trays (target ending inventory) - 13,000 trays (beginning inventory)
04

Calculate the result

Now, we simply need to perform the arithmetic to find the number of trays necessary for production: Number of trays budgeted for production = 201,000 + 29,000 - 13,000 Number of trays budgeted for production = 230,000 - 13,000 Number of trays budgeted for production = 217,000 trays Coby Company needs to produce 217,000 serving trays in 2018 to meet its sales expectations and reach its target ending inventory.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Cost Accounting
Cost accounting is a vital aspect of any manufacturing business. It involves tracking, recording, and analyzing costs associated with the production process to ensure efficient operations and financial reporting. This type of accounting is crucial for setting prices, controlling expenditures, and budgeting for future costs.

Within cost accounting, producing a budget is essential. It provides a financial roadmap for the business and ensures that resources are allocated efficiently. The production budget, in particular, focuses on the costs of manufacturing goods and is directly related to the sales budget. It outlines the number of units that must be produced to meet sales goals and maintain appropriate inventory levels.

In the context of the exercise, the cost accounting process would involve not only calculating the number of trays to be produced but also estimating the cost to produce each tray. This information is fundamental when crafting a budget that accurately reflects the financial resources needed for production. The final production budget would include material costs, labor, overhead expenses, and any other costs directly tied to production.
Inventory Management
Inventory management plays a pivotal role in the overall health of a company's operations and finances. Effective inventory management ensures that a company maintains the right level of stock to meet customer demand without incurring unnecessary holding costs or experiencing stockouts.

A critical part of inventory management is determining the appropriate levels of beginning and ending inventory. These figures are more than mere placeholders in a formula; they represent strategic decisions based on past data, forecasted sales, and market trends. A higher ending inventory might be kept to prepare for an anticipated increase in sales or to guard against supply chain disruptions. Conversely, a lower ending inventory could be preferable to reduce carrying costs or if sales are expected to decline.

The figures provided in the textbook solution exercise are a clear example of the practical application of inventory management principles. The company aims to increase its inventory by the end of the year, suggesting expectations for growth or simply a strategic buffer to ensure a smooth production and sales operation.
Budgeted Production Calculation
The final piece of this cost-accounting puzzle is the budgeted production calculation. This calculation bridges the gap between sales expectations and inventory requirements, directly influencing the production schedule and the resources allocated for it.

To calculate the budgeted production, you need to take into account the expected sales, as these drive demand for production. From there, you consider both the beginning and target ending inventory levels to ensure you're not overproducing (which can lead to excess inventory and higher holding costs) or underproducing (which can result in lost sales and dissatisfied customers).

The formula demonstrated in the exercise—expected sales plus target ending inventory minus beginning inventory—provides a clear guide for the Coby Company's production needs. By plugging in the given values and performing the calculation, we arrive at the budgeted production quantity for the year. This calculated number, 217,000 trays, is crucial because it sets the production pace and resource allocation for the year, integrating cost accounting and inventory management into a cohesive operational strategy.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

How can sensitivity analysis be used to increase the benefits of budgeting?

Define Kaizen budgeting.

Cash budgeting, budgeted balance sheet (Continuation of 6 -42) (Appendix) Refer to the information in Problem \(6-42\) Budgeted balances at January 31,2018 are as follows: Customer invoices are payable within 30 days. From past experience, Skulas's accountant projects \(40 \%\) of invoices will be collected in the month invoiced, and \(60 \%\) will be collected in the following month. Accounts payable relates only to the purchase of direct materials. Direct materials are purchased on credit with \(50 \%\) of direct materials purchases paid during the month of the purchase, and \(50 \%\) paid in the month following purchase. Fixed manufacturing overhead costs include \( 64,000\) of depreciation costs and fixed nonmanufacturing overhead costs include \( 10,000\) of depreciation costs. Direct manufacturing labor and the remaining manufacturing and nonmanufacturing overhead costs are paid monthly. All property, plant, and equipment acquired during January 2018 were purchased on credit and did not entail any outflow of cash. There were no borrowings or repayments with respect to long-term liabilities in January 2018 On December \(15,2017,\) Skulas's board of directors voted to pay a \( 160,000\) dividend to stockholders on January 31,2018 1\. Prepare a cash budget for January \(2018 .\) Show supporting schedules for the calculation of collection of receivables and payments of accounts payable, and for disbursements for fixed manufacturing and nonmanufacturing overhead. 2\. Skulas is interested in maintaining a minimum cash balance of \( 120,000\) at the end of each month. Will Skulas be in a position to pay the \( 160,000\) dividend on January \(31 ?\) 3\. Why do Skulas's managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? 4\. Prepare a budgeted balance sheet for January 31,2018 by calculating the January 31,2018 balances in (a) cash (b) accounts receivable (c) inventory (d) accounts payable and (e) plugging in the balance for stockholders' equity.

Sales budget, service setting. In 2017 , Hart \(\&\) Sons, a small environmental-testing firm, performed 11,400 radon tests for \(260\) each and 15,000 lead tests for \(210\) each. Because newer homes are being built with lead-free pipes, lead-testing volume is expected to decrease by \(12 \%\) next year. However, awareness of radon-related health hazards is expected to result in a \(5 \%\) increase in radon-test volume each year in the near future. Jim Hart feels that if he lowers his price for lead testing to \(200\) per test, he will have to face only a \(4 \%\) decline in lead-test sales in 2018 . 1\. Prepare a 2018 sales budget for Hart \(\&\) Sons assuming that Hart holds prices at 2017 levels. 2\. Prepare a 2018 sales budget for Hart \(\&\) Sons assuming that Hart lowers the price of a lead test to \( 200\). Should Hart lower the price of a lead test in 2018 if the company's goal is to maximize sales revenue?

Comprehensive operating budget. Skulas, Inc., manufactures and sells snowboards. Skulas manufactures a single model, the Pipex. In late 2017 , Skulas's management accountant gathered the following data to prepare budgets for January 2018 : Skulas's CEO expects to sell 2,900 snowboards during January 2018 at an estimated retail price of \(650\) per board. Further, the CEO expects 2018 beginning inventory of 500 snowboards and would like to end January 2018 with 200 snowboards in stock. Variable manufacturing overhead is \( 7\) per direct manufacturing labor-hour. There are also \( 81,000\) in fixed manufacturing overhead costs budgeted for January \(2018 .\) Skulas combines both variable and fixed manufacturing overhead into a single rate based on direct manufacturing labor-hours. Variable marketing costs are allocated at the rate of \( 250\) per sales visit. The marketing plan calls for 38 sales visits during January 2018\. Finally, there are \( 35,000\) in fixed nonmanufacturing costs budgeted for January 2018 Other data include: The inventoriable unit cost for ending finished-goods inventory on December \(31,2017,\) is \( 374.80 .\) Assume Skulas uses a FIF0 inventory method for both direct materials and finished goods. Ignore work in process in your calculations. 1\. Prepare the January 2018 revenues budget (in dollars). 2\. Prepare the January 2018 production budget (in units). 3\. Prepare the direct material usage and purchases budgets for January 2018 4\. Prepare a direct manufacturing labor costs budget for January 2018 5\. Prepare a manufacturing overhead costs budget for January 2018 6\. What is the budgeted manufacturing overhead rate for January \(2018 ?\) 7\. What is the budgeted manufacturing overhead cost per output unit in January \(2018 ?\) 8\. Calculate the cost of a snowboard manufactured in January 2018 . 9\. Prepare an ending inventory budget for both direct materials and finished goods for January 2018. 10\. Prepare a cost of goods sold budget for January 2018 11\. Prepare the budgeted income statement for Skulas, Inc., for January 2018 12\. What questions might the CEO ask the management team when reviewing the budget? Should the CEO set stretch targets? Explain briefly. 13\. How does preparing the budget help Skulas's management team better manage the company?

See all solutions

Recommended explanations on Math Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.