Micromedia offers computer training seminars on a variety of topics. In the seminars each student works at a personal computer, practicing the particular activity that the instructor is presenting. Micromedia is currently planning a two-day seminar on the use of Microsoft Excelin statistical analysis. The projected fee for the seminar is $600 per student. The cost for the conference room, instructor compensation, lab assistants, and promotion is $10,850. Micromedia rents computers for its seminars at a cost of $125 per computer per day.(a) Develop a model for the total cost (C) to put on the seminar. Let x represent the number of students who enroll in the seminar.C =(b) Develop a model for the total profit (P) if x students enroll in the seminar.P =(c) Micromedia has forecast an enrollment of 55 students for the seminar. How much profit will be earned if their forecast is accurate?P(55) = $(d) Compute the break-even point.

Answered: Image /qna-images/answer/0e31f358-c73d-4c0e-a21d-687dcac9f865.jpg

Answered: (a) Develop a model for the total cost…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

To find the profit on the varying prices of a candy bar you will use: a. One variable Data Table b. Two variable Data Table c. Goal Seek d. None of these
You have been pricing Samsung-Galaxy SmartWatch in several stores. Three stores have the identical price of $600. Each store charges 12 percent APR, has a 30-day grace period, and sends out bills on the first of the month. On further investigation, you find that store A calculates the finance charge by using the average daily balance method, store B uses the adjusted balance method, and store C using the previous balance method. Assume you purchased the SmartWatch on May 5 and made a $100 payment on June 15. What will the finance charge for June be if you made your purchase from store A? From store B? From store C?
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Dog
The data shown are quarterly revenues (in Sthousands) from Roget's Books from 2013-Q1 through 2020-Q2. 6. Quarter 2013-1 2013-2 2013-3 2013-4 2014-1 2014-2 2014-3 2014-4 2015-1 2015-2 2015-3 2015-4 2016-1 2016-2 2016-3 2016-4 2017-1 2017-2 2017-3 2017-4 Revenue 2372 2740 2518 4708 2392 Quarter 2018-1 2018-2 2018-3 2018-4 2019-1 2019-2 2019-3 2019-4 2020-1 2020-2 Revenue 2725 2924 3118 5112 2777 2949 1:27:04 2811 2685 4795 2812 2893 2848 4894 2687 2903 2674 4871 2844 2933 3237 5350 3035 3028 2791 5252 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = | (Round to 1 decimal places.) b. Determine the specific index for each quarter places.) dexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for…
b6 need urgent in 15 minutes
Solve it
A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., the year 2014 = 155, the year 2015 = 140 and year 2016 = 170), and we want to weight the year 2014 at 30%, the year 2015 at 35% and year 2016 at 40%, which of the following is the weighted moving average forecast for the year 2017? 170 158 O 164 O 160
An airline company offers four fairs as shown in the table below. The demand distribution for each fare is normal with mean and standard deviation as given in the table. Find an estimate of the protection levels for the classes using the heuristic EMSR-a. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
ou have been pricing Samsung-Galaxy SmartWatch in several stores. Three stores have the identical price of $400. Each store charges 18 percent APR, has a 30-day grace period, and sends out bills on the first of the month. On further investigation, you find that store A calculates the finance charge by using the average daily balance method, store B uses the adjusted balance method, and store C using the previous balance method. Assume you purchased the SmartWatch on May 5 and made a $100 payment on June 15. What will the finance charge for June be if you made your purchase from store A? From store B? From store C?
48- The maximum number of sales that can occur in a given period to an individual or businesses that are willing to sell in a given market is known as: a. Product demand b. Market potential c. Market demand d. All the options are correct
Week Demand of beef 1 500 2 550 3 600 4 720 5 780 6 800 Corresponding weights are W1=0.6, W2=0.4 and W3=0.3 The 3-week weighted moving average to forecast- Week Demand of beef 3- weeks weighted moving average forecast 1 500 2 550 3 600 4 720 (500×0.6+550×0.4+600×0.3) / (0.6+0.4+0.3) = 538.46 5 780 (550×0.6+600×0.4+720×0.3) / (0.6+0.4+0.3) = 604.61 (600×0.6+720×0.4+780×0.3) / (0.6+0.4+0.3) = 678.46 Forecast for week 4,5 and 6 = 538.46, 604.61 and 678.46 4-week weighted moving average to forecast- Corresponding weights are W1=0.6, W2=0.4, W3=0.3, and W4=0.2 Week Demand of beef 4-weeks weighted moving average forecast 1 500 2 550 3 600 4 720 5 780 (500×0.6+550×0.4+600×0.3+720×0.2) / (0.6+0.4+0.3+0.2) = 562.66 (550×0.6+600×0.4+720×0.3+780×0.2) / (0.6+0.4+0.3+0.2) = 628 Forecast for week 6 and 7 = 562.66, 628…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS