Cincinnati Tool Company (CTC) manufactures a line of electric garden tools that are sold in general hardware stores. The company's controller, Will Fulton, has just received the sales forecast for the coming year for CTC's three products: hedge clippers, weeders, and leaf blowers. CTC has experienced considerable variations in sales volumes and variable costs over the past two years, and Fulton belleves the forecast should be carefully evaluated from a cost-volume-profit viewpoint. The preliminary budget information for 20x2 follows: Unit sales Unit selling price Variable manufacturing cost per unit Variable selling cost per unit Weeders 50,000 $ 28 13 5 Hedge Clippers 50,000 36 $ 12 4 Leaf Blowers 100,000 48 $ 25 6 For 20x2, CTC's fixed manufacturing overhead is budgeted at $2,000,000, and the company's fixed selling and administrative expenses are forecasted to be $600,000. CTC has a tax rate of 40 percent.

Cincinnati Tool Company (CTC) manufactures a line of electric garden tools that are sold in general hardware stores. The company's controller, Will Fulton, has just received the sales forecast for the coming year for CTC's three products: hedge clippers, weeders, and leaf blowers. CTC has experienced considerable variations in sales volumes and variable costs over the past two years, and Fulton belleves the forecast should be carefully evaluated from a cost-volume-profit viewpoint. The preliminary budget information for 20x2 follows: Unit sales Unit selling price Variable manufacturing cost per unit Variable selling cost per unit Weeders 50,000 $ 28 13 5 Hedge Clippers 50,000 36 $ 12 4 Leaf Blowers 100,000 48 $ 25 6 For 20x2, CTC's fixed manufacturing overhead is budgeted at $2,000,000, and the company's fixed selling and administrative expenses are forecasted to be $600,000. CTC has a tax rate of 40 percent.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter6: Statistical Inference

Section: Chapter Questions

Problem 43P: The Port Authority sells a wide variety of cables and adapters for electronic equipment online. Last...

See similar textbooks

Similar questions

Data 1-2-3 is a top-selling electronic spreadsheet product. is about to release version 5.0. It divides its customers into two groups: new customers and upgrades customers (those who previously purchased Data 1-2-3, 4.0, or earlier versions). Although the same physical product is provided to each customer group, sizable differences exist in selling prices and variable marketing costs: New Customers Upgrade Customers Selling price $225 $125 Variable costs Manufacturing $30 $30 Marketing 65 95 15 45 Contribution margin $130 $80 The fixed costs of Data 1-2-3 5.0 are $16,500,000. The planned sales mix in units is 60% new customers and 40% upgrade customers.…
(Q.7) Data 1-2-3 is a top-selling electronic spreadsheet product Data is about to release version 5.0. 11 divides its customers into two groups: new customers and upgrade customers (those who previously purchased Data 1-2-3, 4.0 or earlier versions). Although the same physical product is provided to each customer group, sizable differences exist in selling prices and variable marketing costs: New Customers $275 Selling price Variable costs Manufacturing Marketing Contribution margin $35 65 100 $175 Upgrade Customers $100 $35 15 50 $ 50 The fixed costs of Data 1-2-3, 5.0 are $15,000,000. The planned sales mix in units is 60% new customers and 40% upgrade customers. Questions: 1. Calculate the Data 1-2-3, 5.0 breakeven point in units (number of bundles, new customers, upgrade customers) assuming that the planned 60% 40% sales mix is attained? 2. If the sales mix is altained, what is the operating income when 220,000 total units are sold? 9
Required Information [The following information applies to the questions displayed below.] UR Safe Systems Installs home security systems. Two of its systems, the ICU 100 and the ICU 900, have these characteristics: Design Specifications Video cameras Video monitors Motion detectors Floodlights Alarms Wiring Installation 1,050 feet 21 hour The ICU 100 sells for $860 Installed, and the ICU 900 sells for $1,570 Installed. 1. Current profit margin 2. ICU 100 2 2 3 1 5 650 feet 11 hour Required: 1. What are the current gross profit margin percentages on both systems? 2. UR Safe's management believes that it must drop the price on the ICU 100 to $800 and on the ICU 900 to $1,440 to remain competitive in the market. Recalculate gross profit margin percentages for both products at these price levels and then compute the target cost needed for each product to maintain the current gross profit margin percentages. Profit margin Target cost (For all requirements, round your percentage answers to…
Required information Problem 5-26 (Algo) CVP Applications; Break-Even Analysis; Graphing [LO5-1, LO5-2, LO5-4, LO5-5] [The following information applies to the questions displayed below.] The Fashion Shoe Company operates a chain of women's shoe shops that carry many styles of shoes that are all sold at the same price. Sales personnel in the shops are paid a sales commission on each pair of shoes sold plus a small base salary. The following data pertains to Shop 48 and is typical of the company's many outlets: Selling price Variable expenses: Invoice cost Sales commission Total variable expenses Per Pair of Shoes $ 40.00 $ 16.00 4.00 $ 20.00 Fixed expenses: Advertising Rent Salaries Total fixed expenses Annual $ 45,000 31,000 155,000 $ 231,000 Problem 5-26 (Algo) Part 5 5. Refer to the original data. As an alternative to (4) above, the company is considering paying the Shop 48 store manager 55 cents commission on each pair of shoes sold in excess of the break-even point. If this change…
5 Revenue mix, new and upgrade customers. Zapo 1-2-3 is a top-selling spreadsheet product. Zapo is about to release Version 5.0. It groups its customers into two groups new customers and upgrade customers (those who previously purchased Zapo 1-2-3 Version 4.0 or earlier). Although the same physical product is provided to each customer group, sizable differences exist in their selling prices and variable marketing costs: Selling price Variable cost: Manufacturing Marketing New Customers $25 65 $210 90 a. New 50%/upgrade 50%. b. New 90% / upgrade 10% Upgrade Customers $120 $25 15 40 The fixed costs of Zapo 5.0 are $14,000,000. The planned revenue mix in units is 60% new customers and 40% upgrade customers. REQUIRED 1. What is the Zapo 1-2-3 Version 5.0 breakeven point in units, assuming that the planned 60/40 mix is maintained? 2. If the mix is maintained, what is the operating income when 200,000 units are sold? 3. Show how the breakeven point in units changes with the following…
Please answer questions 4 andd 5 in it's entirety. Please make it easy to define the answer and refer to the images attached. Problem 11-25 (Algo) Volume Trade-Off Decisions [LO11-5, LO11-6] The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Demand Next year (units) Selling Price per Unit Direct Materials Direct Labor Debbie 61,000 $ 20.00 $ 5.40 $ 3.60 Trish 53,000 $ 6.50 $ 2.20 $ 1.44 Sarah 46,000 $ 33.50 $ 8.09 $ 6.30 Mike 44,400 $ 14.00 $ 3.10 $ 4.50 Sewing kit 336,000 $ 9.10 $ 4.30 $ 0.99 The following additional information is available: The company’s plant has a capacity of 113,140 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The…
! Required information [The following information applies to the questions displayed below.] UR Safe Systems installs home security systems. Two of its systems, the ICU 100 and the ICU 900, have these characteristics: Design Specifications Video cameras Video monitors Motion detectors Floodlights Alarms Wiring Installation ICU 100 2 2 1. Current profit margin 2. Profit margin Target cost WEIN ICU 100 1 % % 3 3 710 feet 11 hour 1,150 feet 21 hour The ICU 100 sells for $980 installed, and the ICU 900 sells for $1,690 installed. Required: 1. What are the current gross profit margin percentages on both systems? 2. UR Safe's management believes that it must drop the price on the ICU 100 to $920 and on the ICU 900 to $1,560 to remain competitive in the market. Recalculate gross profit margin percentages for both products at these price levels and then compute the target cost needed for each product to maintain the current gross profit margin percentages. (For all requirements, round your…
Required information Problem 5-68 (Static) Cost Estimation: Simple and Multiple Regression Using a Spreadsheet (Appendix A) (LO 5-4, 5, 6, 9) [The following information applies to the questions displayed below.] Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following information from last year's operations (revenues and costs in thousands of dollars): Costs Employees 101$ 4,214 102 2,894 103 5, 181 104 3,998 105 3,676 106 107 108 109 110 2,959 111 4,179 112 113 Store 114 115 3, 319 5, 029 2,374 4, 688 3, 200 2,556 4, 655 2,986 39$ 29 47 38 33…
Please answer questions 1 through 3. Please make the answers very clear and refer to the images attached.Notice that the first three questions require answers for Debbie, Trish, Sarah, Mike and Sewing Kit. Problem 11-25 (Algo) Volume Trade-Off Decisions [LO11-5, LO11-6] The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Demand Next year (units) Selling Price per Unit Direct Materials Direct Labor Debbie 61,000 $ 20.00 $ 5.40 $ 3.60 Trish 53,000 $ 6.50 $ 2.20 $ 1.44 Sarah 46,000 $ 33.50 $ 8.09 $ 6.30 Mike 44,400 $ 14.00 $ 3.10 $ 4.50 Sewing kit 336,000 $ 9.10 $ 4.30 $ 0.99 The following additional information is available: The company’s plant has a capacity of 113,140 direct labor-hours per year on a single-shift basis.…
Selecting a Basis for Predicting Shipping Expenses (Requires Computer Spreadsheet*) Cambridge SoundWorks sell portable speakers systems and bluetooth headphones. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipped, weight shipped, or sales value of units shipped- has the closest relationship with shipping expenses. The following information is available: Weight Sales Value of Shipping Month Units Shipped Shipped (lbs.) Units Shipped Expenses May 10,000 7,500 $350,000 $38,000 June 12,000 8,760 July 15,000 9,200 August 20,000 10,500 432,000 42,000 420,000 50,100 400,000 72,500 September 12,000 7,600 300,000 41,000 October 8,000 6,000 320,000 35,600 Required a. With the aid of a spreadsheet program, determine whether units shipped, weight shipped, or sales value of units shipped has the closest relationship with shipping expenses. Complete the r-squared values between each possible independent…
Zapo 1-2-3 is a top-selling electronic spreadsheet product. Zapo is about to release version 5.0. It divides its customers into two groups: new customers and upgrade customers (those who previously purchased Zapo 1-2-3, 4.0 or earlier versions). Although the same physical product is provided to each customer group, sizable differences exist in selling prices and variable marketing costs: E (Click the icon to view the price and cost information.) The fixed costs of Zapo 1-2-3 5.0 are $13,500,000. The planned sales mix in units is 60% new customers and 40% upgrade customers. Read the requirements. Requirement 1. What is the Zapo 1-2-3 5.0 breakeven point in units, assuming that the planned 60% / 40% sales mix is attained? Begin by determining the sales mix. For every bundle, units are sold to new customers, and units are sold to customer who bought upgrades. Data Table New Customers Upgrade Customers Selling price $ 225 $ 120 Variable costs Manufacturing $ 20 $ 20 60 80 25 Marketing $…
Check Exercise 6-15 (Algo) Approaches for estimating stand-alone selling prices (LO6-6) Video Planet (VP) sells a big screen TV package consisting of a 60-inch plasma TV, a universal remote, and on-site installation by VP staff. The installation includes programming the remote to have the TV interface with other parts of the customer's home entertainment system. VP concludes that the TV, remote, and installation service are separate performance obligations. VP sells the 60-inch TV separately for $2,110 and sells the remote separately for $280, and offers the entire package for $2,620. VP does not sell the installation service separately. VP is aware that other similar vendors charge $330 for the installation service. VP also estimates that it incurs approximately $280 of compensation and other costs for VP staff to provide the installation service. VP typically charges 40% above cost on similar sales. ok ht nt Required: 1. to 3. Calculate the stand-alone selling price of the…