Sherpa Sensors Pty Ltd manufactures high-tech temperature sensors for various medical purposes, such as MRI imaging...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sherpa Sensors Pty Ltd manufactures high-tech temperature sensors for various medical purposes, such as MRI imaging equipment and ultrasound scanners, and electronic applications, such as electrical appliances. There are four distribution methods for the temperature sensors, as shown in Table 1. Because of differing distribution and promotional costs, the product's profitability will vary with the distribution method. In addition, the advertising cost and the personal sales effort required will vary with the distribution method. The following table summarises the sensors contribution to profit, advertising cost, and personal sales effort. Distribution Method Medical distributors Electrical distributors National retail stores Online Profit per Unit Sold ($) 900 850 700 820 Advertising Cost per Unit Sold ($) 10 8 9 15 Personal Sales Effort per Unit Sold (minutes) 50 23 25 1 Sherpa Sensors Pty Ltd has set the advertising budget at $65000, and a maximum of 3000 hours of salesforce time is available for the sales effort at the cost of $45/hour. Management also decided to produce exactly 6000 sensors for the current production period. Finally, an ongoing contract with the national chain of retail stores requires that at least 1500 units be distributed through this distribution method. Sherpa Sensors Pty Ltd needs to establish a strategy that will provide for the distribution of the sensors to maximise the overall profitability of the sensor production. Decisions must be made about how many units should be allocated to each of the four distribution methods and how to allocate the advertising budget and salesforce effort to each of the four distribution methods. For the situation given above: a) Determine the decision variables and describe your reasoning. b) Formulate the situation into a Mathematical Programming problem. c) Explain what type of Mathematical Programming problem it is formulated as. d) Find the optimal solution using Microsoft Excel's Solver. Include the answer report in your file. (10 marks) (5 marks) (5 marks) (5 mark) e) Are all the distribution methods used for the solution found in (d)? If not, should management consider removing one of the distribution methods? If yes, what can the management do to improve the profit further? (10 marks) f) What would your recommendation be regarding the contractual commitment to the retail stores for the solution found in (d)? For example, could they be more profitable if they reduced or increased their level of commitment (i e. the minimum number of units sold)? (10 marks) (5 marks) g) List the binding and non-binding constraints for the optimal solution in (d). Sherpa Sensors Pty Ltd manufactures high-tech temperature sensors for various medical purposes, such as MRI imaging equipment and ultrasound scanners, and electronic applications, such as electrical appliances. There are four distribution methods for the temperature sensors, as shown in Table 1. Because of differing distribution and promotional costs, the product's profitability will vary with the distribution method. In addition, the advertising cost and the personal sales effort required will vary with the distribution method. The following table summarises the sensors contribution to profit, advertising cost, and personal sales effort. Distribution Method Medical distributors Electrical distributors National retail stores Online Profit per Unit Sold ($) 900 850 700 820 Advertising Cost per Unit Sold ($) 10 8 9 15 Personal Sales Effort per Unit Sold (minutes) 50 23 25 1 Sherpa Sensors Pty Ltd has set the advertising budget at $65000, and a maximum of 3000 hours of salesforce time is available for the sales effort at the cost of $45/hour. Management also decided to produce exactly 6000 sensors for the current production period. Finally, an ongoing contract with the national chain of retail stores requires that at least 1500 units be distributed through this distribution method. Sherpa Sensors Pty Ltd needs to establish a strategy that will provide for the distribution of the sensors to maximise the overall profitability of the sensor production. Decisions must be made about how many units should be allocated to each of the four distribution methods and how to allocate the advertising budget and salesforce effort to each of the four distribution methods. For the situation given above: a) Determine the decision variables and describe your reasoning. b) Formulate the situation into a Mathematical Programming problem. c) Explain what type of Mathematical Programming problem it is formulated as. d) Find the optimal solution using Microsoft Excel's Solver. Include the answer report in your file. (10 marks) (5 marks) (5 marks) (5 mark) e) Are all the distribution methods used for the solution found in (d)? If not, should management consider removing one of the distribution methods? If yes, what can the management do to improve the profit further? (10 marks) f) What would your recommendation be regarding the contractual commitment to the retail stores for the solution found in (d)? For example, could they be more profitable if they reduced or increased their level of commitment (i e. the minimum number of units sold)? (10 marks) (5 marks) g) List the binding and non-binding constraints for the optimal solution in (d).
Expert Answer:
Related Book For
Accounting for Decision Making and Control
ISBN: 978-0078025747
8th edition
Authors: Jerold Zimmerman
Posted Date:
Students also viewed these mathematics questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Assume that global lightning on the Earth constitutes a constant current of 1.00 kA between the ground and an atmospheric layer at potential 260 kV. (a) Find the power of terrestrial lightning. (b)...
-
Change from Fair Value to Equity Method On January 3, 2009, Martin Company purchased for $500,000 cash a 10% interest in Renner Corp. On that date the net assets of Renner had a book value of...
-
Abner Company purchases a patent for $156,000 on January 2, 2025. Its estimated useful life is 6 years. a. Prepare the journal entry to record amortization expense for the first year. b. Show how...
-
The heat of combustion of a gas is generally determined with the help of the (a) Bomb calorimeter (b) Dean and Stark apparatus (c) Optical pyrometer (d) Orsat analyser.
-
The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016 July 1. Issued $74,000,000 of 20-year, 11% callable bonds dated July 1, 2016, at a market...
-
Pick an industry in the Resilinc 2018 Annual report. Describe uncertainties in the industry and possible risk mitigation. Search the internet for one or two examples of that industry and how they...
-
Valencia Products makes automobile radar detectors and assembles two models LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the...
-
I will invest $500 per quarter for my retirement at 7.3% compounding quarterly for 32 years. I have a choice of making that payment of $500 at the beginning or the end of the quarter (regular annuity...
-
Jordan Company reported the following data regarding the product it sells: Sales price $ 5 0 Contribution margin ratio 1 0 % Fixed costs $ 1 5 0 , 0 0 0 Required Use the contribution margin ratio...
-
Shannon Company segments its income statement into North and South Divisions. The company s overall sales, contribution margin ratio, and net operating income are $ 3 5 0 , 0 0 0 , 3 2 % , and $ 7 ,...
-
Noida Services Corporation had the following accounts and balances: Accounts payable 1 8 , 0 0 0 Equipment 2 1 , 0 0 0 Accounts receivable 3 , 0 0 0 Land 2 1 , 0 0 0 Buildings ? Unearned service...
-
A company has sales of $ 2 2 5 , 0 0 0 cost of goods sold of $ 1 1 5 , 0 0 0 average inventory during the year of $ 6 5 , 0 0 0 and ending inventory of $ 8 0 , 0 0 0 . What is the company's inventory...
-
A firm is considering taking a project that will produce $12 million of revenue per year. Cash expenses will be $5 million, and depreciation expenses will be $1 million per year. The project would...
-
Home Infusion provides an average of 11 home health visits a day at an average net charge of $116 per visit, for $830 in average daily billings (ADB). They provide services approximately 215 days per...
-
Don Griffin worked as an accountant at a local accounting firm for five years after graduating from university. Recently, he opened his own accounting practice, which he operates as a corporation....
-
Coase Farm grows soybeans near property owned by Taggart Railroad. Taggart can build zero, one, or two railroad tracks adjacent to Coase Farm, yielding a net present value of $ 0, $ 9 million, or $...
-
Mr. Jones intends to retire in 20 years at the age of 65. As yet he has not provided for retirement income, and he wants to set up a periodic savings plan to do this. If he makes equal annual...
-
Beckett is a large car dealership that sells several automobile manufacturers new cars (Toyota, Ford, Lexus, and Subaru). Beckett also consists of a Pre- owned Cars Department and a large service...
-
The state of strain at the point on the bracket has components of \(\epsilon_{x}=350\left(10^{-6} ight), \quad \epsilon_{y}=-860\left(10^{-6} ight)\), \(\gamma_{x y}=250\left(10^{-6} ight)\). Use the...
-
The state of stress stress at a critical point on a thin steel shell is shown. Determine if yielding has occurred using the maximum distortion energy theory. The yield stress for the steel is...
-
The A-36 steel post is subjected to the forces shown. If the strain gages \(a\) and \(b\) at point \(A\) give readings of \(\epsilon_{a}=300\left(10^{-6} ight)\) and \(\epsilon_{b}=175\left(10^{-6}...
Study smarter with the SolutionInn App