/*! 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 25 Revenues, production, and purcha... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Revenues, production, and purchases budgets. The Yucatan Co. in Mexico has a division that manufactures bicycles. Its budgeted sales for Model \(\mathrm{XG}\) in 2018 are 95,000 units. Yucatan's target ending inventory is 7,000 units, and its beginning inventory is 11,000 units. The company's budgeted selling price to its distributors and dealers is 3,500 pesos per bicycle. Yucatan buys all its wheels from an outside supplier. No defective wheels are accepted. Yucatan's needs for extra wheels for replacement parts are ordered by a separate division of the company. The company's target ending inventory is 14,000 wheels, and its beginning inventory is 16,000 wheels. The budgeted purchase price is 400 pesos per wheel. 1\. Compute the budgeted revenues in pesos. 2\. Compute the number of bicycles that Yucatan should produce. 3\. Compute the budgeted purchases of wheels in units and in pesos. 4\. What actions can Yucatan's managers take to reduce budgeted purchasing costs of wheels assuming the same budgeted sales for Model XG?

Short Answer

Expert verified
The budgeted revenues for Yucatan Co. are 332,500,000 pesos, and they should produce 91,000 bicycles. The budgeted purchases of wheels are 180,000 units, costing 72,000,000 pesos. To reduce budgeted purchasing costs of wheels, Yucatan's managers can negotiate lower prices with suppliers, explore alternative suppliers, optimize production to reduce defects, implement inventory management techniques, and order in bulk for potential discounts.

Step by step solution

01

1. Budgeted Revenues

To compute the budgeted revenues, we need to multiply the budgeted sales (units) by the budgeted selling price per bicycle. Budgeted revenues = Budgeted sales (units) × Budgeted selling price per bicycle Budgeted_revenues = 95000 × 3500 Budgeted_revenues = 332,500,000 pesos
02

2. Number of Bicycles to Produce

To compute the number of bicycles Yucatan should produce, we will first find the total number of bicycles needed, considering the target ending inventory, and then subtract the beginning inventory. Total bicycles needed = Budgeted sales + Target ending inventory - Beginning inventory. Total_bicycles_needed = 95,000 + 7,000 - 11,000 Total_bicycles_needed = 91,000 bicycles
03

3. Budgeted Purchases of Wheels in Units and Pesos

First we will find the number of wheels needed to produce the bicycles, considering the target ending inventory for wheels, and then subtract the beginning inventory of wheels. Total wheels needed = Total_bicycles_needed × 2 (each bicycle has 2 wheels) + Target ending inventory - Beginning inventory Total_wheels_needed = 91,000 × 2 + 14,000 - 16,000 Total_wheels_needed = 180,000 wheels Next, we will compute the budgeted purchases in pesos by multiplying the total wheels needed with the budgeted purchase price per wheel. Budgeted_purchases_pesos = Total_wheels_needed × Budgeted_purchase_price_per_wheel Budgeted_purchases_pesos = 180,000 × 400 Budgeted_purchases_pesos = 72,000,000 pesos
04

4. Actions to Reduce Budgeted Purchasing Costs of Wheels

Yucatan's managers can take several actions to reduce the budgeted purchasing costs of wheels, assuming the same budgeted sales for Model XG: 1. Negotiate with the wheel supplier to obtain a lower price per unit. 2. Explore alternative suppliers that may offer better prices and maintain the same quality. 3. Optimize the production process to minimize defects, reducing the number of wheels needed for replacement. 4. Implement inventory management techniques to reduce holding costs and the need for excessive safety stock. 5. Order wheels in bulk or combine orders with other divisions of the company to qualify for potential volume discounts.

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.

Budgeted Revenues Calculation
Calculating budgeted revenues is essential for businesses to forecast financial performance. In essence, it involves multiplying the expected sales volume by the product's selling price. For Yucatan Co., the budgeted revenues for Model XG bicycles are computed by taking the budgeted sales of 95,000 units and multiplying them by the selling price of 3,500 pesos per bicycle, resulting in total budgeted revenues of 332,500,000 pesos.

Understanding this calculation helps businesses set financial targets and make informed decisions. It allows Yucatan Co. managers to assess the potential profitability and to structure marketing and sales strategies around these revenue forecasts. Accurate budgeted revenue calculation is crucial for the overall budgeting process, forming a basis for various operational and strategic decisions.
Production Planning
Production planning involves determining the quantity of products that a company should manufacture to meet customer demand while controlling inventory levels. For Yucatan Co., the number of bicycles to be produced is decided by adding the target ending inventory to the budgeted sales and then subtracting the beginning inventory. This results in a need to produce 91,000 bicycles.

Effective production planning ensures that Yucatan has enough bicycles to meet sales forecasts without accumulating excess inventory, which can incur additional costs. This balance is critical for operating efficiency and helps in reducing waste and optimizing resource allocation. Moreover, production planning integrates closely with other areas like procurement, where careful scheduling can negotiate better terms with suppliers.
Inventory Management
Inventory management is the aspect of controlling the inflow and outflow of goods to prevent excessive or insufficient inventory. In Yucatan's case, efficient management of wheel inventories is necessary to ensure smooth production and limit holding costs. The company requires 180,000 wheels to meet its production and inventory targets, which entails adjusting the budgeted purchases accordingly.

The goal for Yucatan is to strike a balance between having enough wheel stock to prevent production delays and reducing the carrying costs associated with holding large inventories. This practice involves accurate forecasting, regular review of stock levels, and adjusting the order quantities as needed to maintain optimal inventory levels that support production without over-investing in inventory.
Cost Reduction Strategies
Cost reduction strategies are imperative in improving a company's profitability. After identifying the budgeted purchasing costs of wheels, Yucatan's managers can adopt several strategies to reduce these costs. Possible actions include negotiating with suppliers for better pricing, exploring alternative suppliers, or ordering in larger quantities to benefit from discounts. Additionally, optimizing the production process to reduce the need for replacement parts can lead to significant savings.

Implementing lean inventory techniques can also help manage costs more effectively. By minimizing holding costs and reducing surplus inventory, the company can lower overall expenses. A thorough analysis can reveal opportunities for bulk purchases or collaborative ordering within the company's divisions, optimizing the supply chain and reducing per-unit costs without compromising on the sales volume of Model XG bicycles.

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

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 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 .

Define rolling budget. Give an example.

Master budget. Which of the following statements is correct regarding the components of the master budget? a. The cash budget is used to create the capital budget. b. Operating budgets are used to create cash budgets. c. The manufacturing overhead budget is used to create the production budget. d. The cost of goods sold budget is used to create the selling and administrative expense budget.

Operating and financial budgets. Which of the following statements is correct regarding the drivers of operating and financial budgets? a. The sales budget will drive the cost of goods sold budget. b. The cost of goods sold budget will drive the units of production budget. c. The production budget will drive the selling and administrative expense budget. d. The cash budget will drive the production and selling and administrative expense budgets.

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.