/*! 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

Responsibility centers. Elmhurst Corporation is considering changes to its responsibility accounting system. Which of the following statements is/are correct for a responsibility accounting system. i. In a cost center, managers are responsible for controlling costs but not revenue. ii. The idea behind responsibility accounting is that a manager should be held responsible for those items that the manager can control to a significant extent. iii. To be effective, a good responsibility accounting system must help managers to plan and to control. iv. costs that are allocated to a responsibility center are normally controllable by the responsibility center manager. 1\. I and Il only are correct. 2\. II and III only are correct. 3\. \(I, \|,\) and \|\| are correct. 4\. \(I, \|\) and \(I V\) are correct

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?

Comprehensive budgeting problem; activity-based costing, operating and financial budgets. Tyva makes a very popular undyed cloth sandal in one style, but in Regular and Deluxe. The Regular sandals have cloth soles and the Deluxe sandals have cloth-covered wooden soles. Tyva is preparing its budget for June 2018 and has estimated sales based on past experience. Other information for the month of June follows: Tyva uses a FIF0 cost-flow assumption for finished-goods inventory. All the sandals are made in batches of 50 pairs of sandals. Tyva incurs manufacturing overhead costs, marketing and general administration, and shipping costs. Besides materials and labor, manufacturing costs include setup, processing, and inspection costs. Tyva ships 40 pairs of sandals per shipment. Tyva uses activity-based costing and has classified all overhead costs for the month of June as shown in the following chart: 1\. Prepare each of the following for June: a. Revenues budget b. Production budget in units c. Direct material usage budget and direct material purchases budget in both units and dollars; round to dollars Direct manufacturing labor cost budget e. Manufacturing overhead cost budgets for setup, processing, and inspection activities f. Budgeted unit cost of ending finished-goods inventory and ending inventories budget g. cost of goods sold budget h. Marketing and general administration and shipping costs budget 2\. Tyva's balance sheet for May 31 follows. Use the balance sheet and the following information to prepare a cash budget for Tyva for June. Round to dollars. \(\cdot\) All sales are on account, \(60 \%\) are collected in the month of the sale, \(38 \%\) are collected the following month, and \(2 \%\) are never collected and written off as bad debts. \(\cdot\) All purchases of materials are on account. Tyva pays for \(80 \%\) of purchases in the month of purchase and \(20 \%\) in the following month. \(\cdot\) All other costs are paid in the month incurred, including the declaration and payment of a \(15,000\) cash dividend in June. \(\cdot\) Tyva is making monthly interest payments of \(0.5 \%\) ( \(6 \%\) per year) on a \(150,000\) long-term loan. \(\cdot\) Tyva plans to pay the \(10,800\) of taxes owed as of May 31 in the month of June. Income tax expense for June is zero. \(\cdot\) \(30 \%\) of processing, setup, and inspection costs and \(10 \%\) of marketing and general administration and shipping costs are depreciation.

Revenues and production budget. Saphire, Inc., bottles and distributes mineral water from the company's natural springs in northern Oregon. Saphire markets two products: 12-ounce disposable plastic bottles and 1 -gallon reusable plastic containers. 1\. For \(2018,\) Saphire marketing managers project monthly sales of 500,000 12-ounce bottles and 130,0001 -gallon containers. Average selling prices are estimated at \(0.30\) per 12 -ounce bottle and \(1.60\) per 1 -gallon container. Prepare a revenues budget for Saphire, Inc., for the year ending December 31,2018 2\. Saphire begins 2018 with 980,000 12-ounce bottles in inventory. The vice president of operations requests that 12 -ounce bottles ending inventory on December \(31,2018,\) be no less than 660,000 bottles. Based on sales projections as budgeted previously, what is the minimum number of 12 -ounce bottles Saphire must produce during \(2018 ?\) 3\. The VP of operations requests that ending inventory of 1 -gallon containers on December \(31,2018,\) be 300,000 units. If the production budget calls for Saphire to produce 1,200,0001 -gallon containers during \(2018,\) what is the beginning inventory of 1 -gallon containers on January \(1,2018 ?\)

Budgeted income statement. \((\mathrm{CMA}, \text { adapted) } \mathrm{Smart}\) Video Company is a manufacturer of videoconferencing products. Maintaining the videoconferencing equipment is an important area of customer satisfaction. A recent downturn in the computer industry has caused the videoconferencing equipment segment to suffer, leading to a decline in Smart Video's financial performance. The following income statement shows results for 2017 : Smart Video's management team is preparing the 2018 budget and is studying the following information: 1\. Selling prices of equipment are expected to increase by \(10 \%\) as the economic recovery begins. The selling price of each maintenance contract is expected to remain unchanged from 2017 2\. Equipment sales in units are expected to increase by 6\%, with a corresponding 6 \% growth in units of maintenance contracts 3\. cost of each unit sold is expected to increase by \(5 \%\) to pay for the necessary technology and quality improvements. 4\. Marketing costs are expected to increase by S290,000, but admininstration costs are expected to remain at 2017 levels 5\. Distribution costs vary in proportion to the number of units of equipment sold 6\. Two maintenance technicians are to be hired at a total cost of \(\$ 160,000\), which covers wages and related travel costs. The objective is to improve customer service and shorten response time 7\. There is no beginning or ending inventory of equipment. 1\. Prepare a budgeted income statement for the year ending December 31,2018 2\. How well does the budget align with Smart Video's strategy? 3\. How does preparing the budget help Smart Video'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.