Question 3A Company produces five products using two machines, two raw materials and labour.The profit per unit for each product, availability of each resource and the requirementof each resource for each product are as below Excel sheet. In addition, each producthas a maximum market demand. The company does not wish to exceed this for anyproduct. The objective is to maximise profit subject to availability of resources andmarket demands.A12 Prod 13 Prod 24 Prod 35 Prod 46 Prod 578B15. 38461530. 769231910 Prod 111 Prod 212 Prod 313 Prod 414 Prod 515161718 Total Profit19 2838. 46150200100CDMax Market Profit/unit1005050200100Machine Machine 20.30.50.40.50.40.80.60.90.50.4$6.00$8.00$5.00$9.00$7.00EFMaterial 1 Material 2 Labour0.50.70.40.80.20.90.30.60.40.5Machine160 KMachine 170.76923<Material 1120<Material 2 205.38462Labour137. 692310.60.60.5G0.40.3HIAvail160400120280300 (1) Formulate the problem in Excel Solver. Present your solver screen.(2) Generate and present your Sensitivity report.(3) As a factory manager, generate a report focus on resource usage and availability.(4) Consider the market demand and pricing, generate a report of profitability.

Answered: Image /qna-images/answer/ec9d3cf1-59f8-4714-ad49-2b68d08bede7.jpg

Answered: A Company produces five products using…

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

Demand(box) 10 11 12 13 14 15 and and more less Possibility 0.1 0.18 0.26 0.24 0.12 0.1 A business that will open a gift shop in Los Angeles is considering making and selling love- themed magnets. It is thought that it will not be possible to order new magnets during the fair period, and magnets that are not sold during the fair period will not be sold later. A box of magnets costs the business $100 and generates $460 from its sale. The table includes predictions about demand probabilities. a-) What is the overstocking cost of the business in dollars/box? b-) How many dollars/box is the missing stocking cost?
A summary of total charges from a small café’s natural gas bills is provided below: Month kJ Cost October 14 $187 November 17 187 December 30 230 January 35 264 February 33 270 March 20 200 Using regression analysis, the expected cost at 40 kJ would be Question 5Answer a. $296 b. $285 c. $102 d. $162
Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
2. Newspaper Stand • A newspaper stand operator has the following sales data for one- year sales of Fine magazine. Quantity Sold per day No. of days quantity sold 10 36 11 54 12 72 13 90 14 108 • The operator wants to know how many copies to stock per day to get the maximum profit. Issues of the magazine sell for $0.50, and costs $0.30. Unsold copies cannot be returned to the distributor.
Q4) Define the following concepts with example. Market Potential Sales Potential Market Share
A method of estimating future demand usedfor decision making in order to set reasonable targets and control orlimit uncertainties or risks.
It might be sensible for a company to benchmark each of its sales reps against: O its other sales reps competitors sales reps sales reps of a firm in a different industry all of the above are true QUESTION 2 Capital sources include: O profits loans stocks all of the above QUESTION 3 The most useful brejakdown of data in a sales analysis is by: O product, package size, grade, or color O customer type geographic region any or all of the above depending on the situation QUESTION 4 Which of the following is NOT a way to stimulate profit growth? O do a better job of holding onto customers
d. Steps involved in classification of ABC analysis?
4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
29 00:24 1 令.l 50 B/s Question no. 02: A Leading manufacturer of Action Figures is about to introduce four new Action Figures. The accompanying table summarizes price and cost data, combined fixed costs equal $650,000. A marketing research study predicts that for each unit sold of Noyan, 2 units of Dogan, 3 units of Bamsi and 4 units of Turgut will be sold. Action Figures Turgut Bamsi Dogan Novan Selling Price (in dollars) 35 26 24 16 Variable Cost/unit (in dollars) 17 12 12 11 Table 1 a) How many product mix units must be sold to break even? b) How does it translate into sales of individual games?
A summary of total charges from a small café's natural gas bills is provided below: Month KJ Cost October 14 $187 November 17 187 December 30 230 January 35 264 February 33 270 20 200 March Using regression analysis, the expected cost at 40 kJ would be a. $296 b. $285 c. $102 d. $162

SEE MORE QUESTIONS

Recommended textbooks for you

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS