Company XYZ is specialized in producing and selling smart watches. The company currently has two products and is planning to improve it profits in the coming years. The company is thinking of introducing a sales commission to encourage its sales people to make more sales and improve company's profitability. When designing the sales :commission the company should base the sales commission on The selling price a O The number of employees .b O The color of the product .c O The contribution margin .d O None of the given answers .e

Company XYZ is specialized in producing and selling smart watches. The company currently has two products and is planning to improve it profits in the coming years. The company is thinking of introducing a sales commission to encourage its sales people to make more sales and improve company's profitability. When designing the sales :commission the company should base the sales commission on The selling price a O The number of employees .b O The color of the product .c O The contribution margin .d O None of the given answers .e

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

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 1P: Kelson Sporting Equipment, Inc., makes two types of baseball gloves: a regular model and a catchers...

See similar textbooks

Similar questions

Brahma Industries sells vinyl replacement windows to home improvement retailers nationwide. The national sales manager believes that if they invest an additional $25,000 in advertising, they would increase sales volume by 10,000 units. Prepare a forecasted contribution margin income statement for Brahma if they incur the additional advertising costs, using this information:
Jolene Askew, manager of Feagan Company, has committed her company to a strategically sound cost reduction program. Emphasizing life-cycle cost management is a major part of this effort. Jolene is convinced that production costs can be reduced by paying more attention to the relationships between design and manufacturing. Design engineers need to know what causes manufacturing costs. She instructed her controller to develop a manufacturing cost formula for a newly proposed product. Marketing had already projected sales of 25,000 units for the new product. (The life cycle was estimated to be 18 months. The company expected to have 50 percent of the market and priced its product to achieve this goal.) The projected selling price was 20 per unit. The following cost formula was developed: Y=200,000+10X1 where X1=Machinehours(Theproductisexpectedtouseonemachinehourforeveryunitproduced.) Upon seeing the cost formula, Jolene quickly calculated the projected gross profit to be 50,000. This produced a gross profit of 2 per unit, well below the targeted gross profit of 4 per unit. Jolene then sent a memo to the Engineering Department, instructing them to search for a new design that would lower the costs of production by at least 50,000 so that the target profit could be met. Within two days, the Engineering Department proposed a new design that would reduce unit-variable cost from 10 per machine hour to 8 per machine hour (Design Z). The chief engineer, upon reviewing the design, questioned the validity of the controllers cost formula. He suggested a more careful assessment of the proposed designs effect on activities other than machining. Based on this suggestion, the following revised cost formula was developed. This cost formula reflected the cost relationships of the most recent design (Design Z). Y=140,000+8X1+5,000X2+2,000X3 where X1=MachinehoursX2=NumberofbatchesX3=Numberofengineeringchangeorders Based on scheduling and inventory considerations, the product would be produced in batches of 1,000; thus, 25 batches would be needed over the products life cycle. Furthermore, based on past experience, the product would likely generate about 20 engineering change orders. This new insight into the linkage of the product with its underlying activities led to a different design (Design W). This second design also lowered the unit-level cost by 2 per unit but decreased the number of design support requirements from 20 orders to 10 orders. Attention was also given to the setup activity, and the design engineer assigned to the product created a design that reduced setup time and lowered variable setup costs from 5,000 to 3,000 per setup. Furthermore, Design W also creates excess activity capacity for the setup activity, and resource spending for setup activity capacity can be decreased by 40,000, reducing the fixed cost component in the equation by this amount. Design W was recommended and accepted. As prototypes of the design were tested, an additional benefit emerged. Based on test results, the post-purchase costs dropped from an estimated 0.70 per unit sold to 0.40 per unit sold. Using this information, the Marketing Department revised the projected market share upward from 50 percent to 60 percent (with no price decrease). Required: 1. Calculate the expected gross profit per unit for Design Z using the controllers original cost formula. According to this outcome, does Design Z reach the targeted unit profit? Repeat, using the engineers revised cost formula. Explain why Design Z failed to meet the targeted profit. What does this say about the use of unit-based costing for life-cycle cost management? 2. Calculate the expected profit per unit using Design W. Comment on the value of activity information for life-cycle cost management. 3. The benefit of the post-purchase cost reduction of Design W was discovered in testing. What direct benefit did it create for Feagan Company (in dollars)? Reducing post-purchase costs was not a specific design objective. Should it have been? Are there any other design objectives that should have been considered?
Salem Electronics currently produces two products: a programmable calculator and a tape recorder. A recent marketing study indicated that consumers would react favorably to a radio with the Salem brand name. Owner Kenneth Booth was interested in the possibility. Before any commitment was made, however, Kenneth wanted to know what the incremental fixed costs would be and how many radios must be sold to cover these costs. In response, Betty Johnson, the marketing manager, gathered data for the current products to help in projecting overhead costs for the new product. The overhead costs based on 30,000 direct labor hours follow. (The high-low method using direct labor hours as the independent variable was used to determine the fixed and variable costs.) All depreciation. The following activity data were also gathered: Betty was told that a plantwide overhead rate was used to assign overhead costs based on direct labor hours. She was also informed by engineering that if 20,000 radios were produced and sold (her projection based on her marketing study), they would have the same activity data as the recorders (use the same direct labor hours, machine hours, setups, and so on). Engineering also provided the following additional estimates for the proposed product line: Upon receiving these estimates, Betty did some quick calculations and became quite excited. With a selling price of 26 and just 18,000 of additional fixed costs, only 4,500 units had to be sold to break even. Since Betty was confident that 20,000 units could be sold, she was prepared to strongly recommend the new product line. Required: 1. Reproduce Bettys break-even calculation using conventional cost assignments. How much additional profit would be expected under this scenario, assuming that 20,000 radios are sold? 2. Use an activity-based costing approach, and calculate the break-even point and the incremental profit that would be earned on sales of 20,000 units. 3. Explain why the CVP analysis done in Requirement 2 is more accurate than the analysis done in Requirement 1. What recommendation would you make?
Kelson Sporting Equipment, Inc., makes two types of baseball gloves: a regular model and a catchers model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Assuming that the company is interested in maximizing the total profit contribution, answer the following: a. What is the linear programming model for this problem? b. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many of each model should Kelson manufacture? c. What is the total profit contribution Kelson can earn with the optimal production quantities? d. How many hours of production time will be scheduled in each department? e. What is the slack time in each department?
Company XYZis specialized in producing and selling smart watches. The company currently has two products and is planning to improve it profits in the coming years. The company is thinking of introducing a sales commission to encourage its sales people to make more sales and improve company's profitability. When designing the sales commission the company should base the sales commission on The color of the product a O The contribution margin b O The number of employees.cO The selling price d O None of the given answers .e O
A furniture's store is considering tow marketing strategies: a loyalty program that would cost $3,000 and increase revenue by $15,000, or a seasonal sale that would cost $5,000 and increase revenue by $25,000. The store's contribution margin is 30%. Which strategy should they pursue if the goal is to maximize ROMI? What about if the goal is to maximize revenue growth?
he 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 DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 62,000 $ 20.50 $ 5.50 $ 3.60 Trish 54,000 $ 7.00 $ 2.30 $ 1.32 Sarah 47,000 $ 34.00 $ 8.24 $ 7.20 Mike 56,000 $ 15.00 $ 3.20 $ 4.80 Sewing kit 337,000 $ 9.20 $ 4.40 $ 0.72 The following additional information is available: The company’s plant has a capacity of 84,160 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $12 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $640,000 per year. Variable overhead costs are $3 per direct labor-hour.…
Kien Sneakers is interested in investigating the level of contribution to profits and overheads that it can expect from a planned new trainer. It intends to set a sales price of €80 per pair. Fixed costs (marketing and general administration) associated with the new trainers are expected to be €350,000. The firm has estimated following range of cost of sales and distribution costs: Cost of Sales (€ per unit ) Cost of Sales (probability distribution) Distribution Costs (€ per unit ) Distribution Costs (probability distribution) 28 0.5 4 0.25 33 0.3 5 0.25 38 0.2 6 0.5 Required: Set up the profit ‘model’ for the new trainer. Estimate the profit contribution under ‘base’ case, ‘best’ case and ‘worst’ case scenarios. Explain the difference between a ‘scenario’ analysis and a ‘sensitivity’ analysis, with examples.
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 DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 50,000 13.50 4.30 3.20 Trish 42,000 5.50 1.10 2.00 Sarah 35,000 21.00 6.44 5.60 Mike 40,000 10.00 2.00 4.00 Sewing kit 325,000 8.00 3.20 1.60 The following additional information is available: The company’s plant has a capacity of 130,000 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $8 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $520,000 per year. Variable overhead costs are $2 per direct labor-hour. All of the company’s…
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 DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 54,000 $ 23.00 $ 4.70 $ 5.40 Trish 46,000 $ 5.00 $ 1.50 $ 1.80 Sarah 39,000 $ 30.00 $ 7.04 $ 8.10 Mike 30,000 $ 14.00 $ 2.40 $ 6.30 Sewing kit 329,000 $ 8.40 $ 3.60 $ 1.35 The following additional information is available: The company’s plant has a capacity of 136,550 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $9 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $560,000 per year. Variable overhead costs are $3 per direct labor-hour.…
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 DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 54,000 $ 23.00 $ 4.70 $ 5.40 Trish 46,000 $ 5.00 $ 1.50 $ 1.80 Sarah 39,000 $ 30.00 $ 7.04 $ 8.10 Mike 30,000 $ 14.00 $ 2.40 $ 6.30 Sewing kit 329,000 $ 8.40 $ 3.60 $ 1.35 The following additional information is available: The company’s plant has a capacity of 136,550 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $9 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $560,000 per year. Variable overhead costs are $3 per direct labor-hour.…
Imogen, the brand manager for ‘Skinsoft’ was reviewing price and promotion alternatives for her brand. She wanted to increase market share, but was unsure whether she should ask for an increase in advertising budget or consider a price promotion. The current volume, price, and cost summary for ‘Skinsoft’ follows: Skinsoft Unit Price £2.00 Unit Variable Cost £1.40 Unit Volume 1,000,000 Imogen thought she might be able to negotiate with her boss and secure either a temporary 10 percent price reduction, or an investment of an incremental £150,000 in advertising. What absolute increase in unit sales and revenue would be necessary to recoup the incremental increase in advertising expenditure? What increase in absolute unit sales and revenue would be necessary to maintain the level of total contribution if the price is reduced by 10 percent? Which of the two alternatives (price reduction or increased advertising) would you recommend to Imogen? Explain your choice.