Andrews Ceramics produces specialty ceramic products for multiple uses. The company is evaluating a proposal from a start-up company that is manufacturing micro generators. The start-up wishes to purchase a quantity of your Type D48 ceramic spools. You believe that micro generators could be a growth market in the future. Being an early supporter of the start-up business could allow for substantial future business for your company. Using regression analysis, determine the cost-estimating equation to manufacture Type D48 ceramic spools. Month Spools Produced Manufacturing Costs January 7,920 $12,416 February 10,571 $11,400 March 7,560 $8,526 April 10,875 $12,420 May 13,695 $17,221 June 12,150 $15,552 July 6,448 $12,760 August 9,801 $15,077 September 13,365 $15,675 October 12,672 $18,018 November 5,360 $10,032 December 8,276 $12,974 What is the lowest price that your company could accept without making the company worse off?

Andrews Ceramics produces specialty ceramic products for multiple uses. The company is evaluating a proposal from a start-up company that is manufacturing micro generators. The start-up wishes to purchase a quantity of your Type D48 ceramic spools. You believe that micro generators could be a growth market in the future. Being an early supporter of the start-up business could allow for substantial future business for your company. Using regression analysis, determine the cost-estimating equation to manufacture Type D48 ceramic spools. Month Spools Produced Manufacturing Costs January 7,920 $12,416 February 10,571 $11,400 March 7,560 $8,526 April 10,875 $12,420 May 13,695 $17,221 June 12,150 $15,552 July 6,448 $12,760 August 9,801 $15,077 September 13,365 $15,675 October 12,672 $18,018 November 5,360 $10,032 December 8,276 $12,974 What is the lowest price that your company could accept without making the company worse off?

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

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?
Liquid Sleeve, Inc. is a company that makes a sealing solution for machine shaft surfaces that have been compromised by abrasion, high pressures,or inadequate lubrication. The manager is considering adding a metal-based nanoparticle (Type Al or Fe) to its solution to increase the product’s performance at high temperatures. The costs associated with each type are estimated. If the company’sMARRis 20% per year, which nanoparticle type should the company select? Utilize a rate of return analysis.
Tesla’s decision to produce a new line of compact and full sized cars resulted in the need to construct either a small plant or a large plant. The best selection of plant size depends on how the marketplace reacts to the new product line. To conduct an analysis, marketing management has decided to view the possible long-run demand as low, medium, or high. The following payoff table shows the projected profit in millions of dollars: Long Run Demand Plant size Low Medium High Small 80 200 350 Large 120 180 190 Construct an influence diagram. Construct a decision tree. Recommend a decision based on the use of the optimistic, conservative, and minimax regret approaches.
XYZ Company has two divisions, the logistics division and foods division. Suppose that the foods division has the opportunity to invest in two projects for the coming year. The first project is a new cheese-coated corn chip that requires additional factory space and special coating machinery. The second project is star-shaped corn chips. That project will require special extruding machinery to create the desired shapes. The outlay required for each investment, the dollar returns, and the ROI are as follows: Project I: Investment - $10,000,000, Operating income - $1,500,000, and ROI – 15% Project II: Investment - $4,000,000, Operating income - $760,000, and ROI – 19% The division is currently earning an ROI of 18 percent, using operating assets of $10 million to generate operating income of $1.8 million. Corporate…
Alyssa Stuart is thinking of starting a store that specializes in handmade Viennese style bentwood chairs. Before opening her store, Alyssa is curious about how her profit, revenue, and variable costs will change depending on the amount she charges for the chairs. Alyssa would like you to perform the work required for this analysis and has given you the data. Here are a few things to consider while you perform your analysis: Current competitive prices for Viennese style bentwood chairs are between $225 and $275 a chair. Variable costs will be either $100 or $150 a chair depending on the types of material Alyssa chooses to use. Fixed costs are $10,000 a month. Create an Excel file containing the following information: Alyssa's chairs - Price One Alyssa's chairs - Price Two Chair Price $ 225 Chair Price $ 275 Variable Cost per chair $ 125 Variable Cost per chair $ 150 Fixed Cost $ 10,000 Fixed Cost $…
You own a furniture manufacturing company. You are looking to expand into glass furniture and need to buy new manufacturing equipment to manufacture this type of furniture. You have researched many suppliers but have found that two machines will best suit your needs. The cost of machine 1 is $90,000, and the cost of machine 2 is $110,000. The estimated net profits the machines will generate are in the attached image. a)Compare the ARR for both machines and decide which machine you should buy. b)Critically evaluate the ARR technique in evaluating investment options.
Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer courses on tile installation, which might also increase the demand for its products. The basic installation course has the following (tentative) price and cost characteristics.
JW Computers is a small firm focused on the assembly and sale of custom computers. The firm is facing stiff competition from low-priced alternatives, and is looking at various solutions to remain competitive and profitable. Current financials for the firm are shown in the table below. In the 1st option, marketing will increase sales by 50%. The 2nd option is Vendor (Supplier) changes, which would result in a decrease of 10% in the cost of inputs. Finally, there is the 3rd OM option, which would reduce production costs by 25%. a. Which of the 3 options would you recommend to the firm if it can only pursue one option? b. What is the new profit for the 1st option? c. What is the new profit for the 2nd option?
Tennis Products, Inc., produces three models of high-quality tennis rackets. The following table contains recent information on the sales, costs, and profitability of thethree models: The company is considering lowering the price of Model A to $27 in an effort toincrease the number of units sold. Based on the results of price changes that havebeen instituted in the past, Tennis Products’ chief economist estimates the arc priceelasticity of demand to be 2.5. Furthermore, she estimates the arc cross elasticity ofdemand between Model A and Model B to be approximately 0.5 and between ModelA and Model C to be approximately 0.2. Variable costs per unit are not expected tochange over the anticipated changes in volume.a. Evaluate the impact of the price cut on the (i) total revenue and (ii) contributionmargin of Model A. Based on this analysis, should the firm lower the price ofModel A?b. Evaluate the impact of the price cut on the (i) total revenue and (ii) contributionmargin for the entire…
Premo Pens, Inc., is in the process of developing a newpen to replace its existing top-of-the-line Executive Model.Market research has identified the critical features the pen must have, and it is estimated that customers would be will-ing to pay $30 for a pen with these features. Premo’s produc-tion manager estimates that with existing equipment it will cost $26 to produce the proposed model. The current Execu-tive Model sells for $24 and has a total production cost of $20. A competitor sells a pen similar to the proposed model,but without Premo’s patented easy retract feature, for $28. Itis estimated to cost the competitor $25 to produce. If Premoseeks to earn a 20 percent return on sales on the new model,which of the following represents the target cost for the newpen?a. $26.00.b. $22.40.c. $24.00.d. $19.80.
The Monty Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market share in the Sunbelt. In order to do so, Monty has decided to locate a new factory in the Panama City area. Monty will either buy or lease a site depending upon which is more advantageous. The site location committee has narrowed down the available sites to the following three very similar buildings that will meet their needs.Building A: Purchase for a cash price of $617,900, useful life 27 years.Building B: Lease for 27 years with annual lease payments of $70,330 being made at the beginning of the year.Building C: Purchase for $655,700 cash. This building is larger than needed; however, the excess space can be sublet for 27 years at a net annual rental of $6,700. Rental payments will be received at the end of each year. The Monty Inc. has no aversion to being a landlord.In which building would you recommend that The Monty Inc. locate, assuming a 12% cost of funds?…
The Bridgeport Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market share in the Sunbelt. In order to do so, Bridgeport has decided to locate a new factory in the Panama City area. Bridgeport will either buy or lease a site depending upon which is more advantageous. The site location committee has narrowed down the available sites to the following three very similar buildings that will meet their needs.Building A: Purchase for a cash price of $ 615,000, useful life 28 years.Building B: Lease for 28 years with annual lease payments of $ 71,570 being made at the beginning of the year.Building C: Purchase for $ 659,900 cash. This building is larger than needed; however, the excess space can be sublet for 28 years at a net annual rental of $ 6,870. Rental payments will be received at the end of each year. The Bridgeport Inc. has no aversion to being a landlord.Click here to view factor tablesIn which building would you recommend…