(Please use the format in the other Spreadsheet Image) Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of Type C bags. They can hire Truck and Mini vans. Each truck can carry 10 bags of Type A bags, 20 bags of Type B bags, and 10 bags of Type C bags. On the other hand, each minivan can carry 20 bags of Type A bags, 5 bags of Type B bags, and 10 bags of Type C bags. Each truck's rental cost is $1000 and each minivan's rental cost is $850. There are only 5 truck drivers available to drive the trucks(Hint: number of trucks should be less than or equal to 5). If Model Inc wants to minimize the transportation cost, how many trucks and vans should they rent? (Possible Answer: $9100)

(Please use the format in the other Spreadsheet Image) Model Inc. has to transport 100 bags of Type A bags, 100 bags of Type B bags, and 100 bags of Type C bags. They can hire Truck and Mini vans. Each truck can carry 10 bags of Type A bags, 20 bags of Type B bags, and 10 bags of Type C bags. On the other hand, each minivan can carry 20 bags of Type A bags, 5 bags of Type B bags, and 10 bags of Type C bags. Each truck's rental cost is $1000 and each minivan's rental cost is $850. There are only 5 truck drivers available to drive the trucks(Hint: number of trucks should be less than or equal to 5). If Model Inc wants to minimize the transportation cost, how many trucks and vans should they rent? (Possible Answer: $9100)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.3: Simple Regression Models

Problem 4P: The file P13_04.xlsx lists the monthly sales for a company (in millions of dollars) for a 10-year...

See similar textbooks

Similar questions

In 2020, a manufacturing company instituted a total quality management (TQM) program producingthe comparative report shown below:[LO 17-5]Summary COQ Report(in thousands)2019 2020 % ChangePrevention costs $ 200 $ 300 +50Appraisal costs 210 315 +50Internal failure costs 190 114 −40External failure costs 1,200 621 −48Total COQ $1,800 $1,350 −25On the basis of this report, which one of the following statements is most likely correct?a. An increase in conformance costs resulted in a higher-quality product and, therefore, a decreasein nonconformance costs.b. An increase in inspection costs was solely responsible for the decrease in quality costs.c. Quality costs such as scrap and rework decreased by 48%.d. Quality costs such as returns and repairs under warranty decreased by 40%.e. Nonconformance costs increased by 50% and conformance costs decreased by approximately 47%.
If X1, X2, ... , Xn constitute a random sample from apopulation with the mean μ, what condition must beimposed on the constants a1, a2, ... , an so thata1X1 + a2X2 +···+ anXnis an unbiased estimator of μ?
USING EXCEL SOLVER Check the image for clarification Q&H Company advertises during soap operas and football games. Each soap opera ad costs $75,000, and each football game ad costs $130,000. If S soap opera ads are purchased, they will be seen by 4S^1/2 million men and 22S^1/2 million women. If F football ads are purchased, they will be seen by 28F^1/2 million men and 10F^1/2 million women. The company wants at least 60 million men and at least 50 million women to see its ads. Determine how to minimize Q&H’s cost of reaching the required number of viewers. *Please show the equations in the cells
The file P14_01.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might be useful in discriminating between these two groups: gender, marital status, annual income level, and age. a. Use logistic regression to classify the consumers on the basis of these explanatory variables. How successful is it? Which variables appear to be most important in the classification? b. Consider a new customer: Male, Married, Income 42,000, Age 47. Use the logistic regression equation to estimate the probability that this customer prefers Regular. How would you classify this person?
The file P02_26.xlsx lists sales (in millions of dollars) of Dell Computer during the period 1987–1997 (where year 1 corresponds to 1987). a. Fit a power and an exponential trend curve to these data. Which fits the data better? b. Use your part a answer to predict 1999 sales for Dell. c. Use your part a answer to describe how the sales of Dell have grown from year to year. d. Search the Web for more recent Dell sales data. Then repeat the preceding parts using all of the data.
Find solution using simplex method.MAX Z = 6x1 + 4x2subject to2x1 + 3x2 ≤ 303x1 + 2x2 ≤ 24x1 + x2 ≥ 3and x1,x2 ≥ 0
In the original OJ Simpson trial, it was accepted that OJ had battered his wife. OJ’s lawyer tried to negate the impact of this information by stating that in a one-year period, only 1 out of 2500 battered women are murdered, so the fact that OJ battered his wife does not give much evidence that he was the murderer. The prosecution (foolishly!) let this go unchallenged. Here are the relevant statistics: In a typical year 6.25 million women are battered, 2500 are battered and murdered, and 2250 of the women who were battered and murdered were killed by the batterer. How should the prosecution have refuted the defense’s argument?
Show that if ˆ is an unbiased estimator of θ andvar()ˆ Z 0, then ˆ 2 is not an unbiased estimator of θ 2.
The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units).Fill in the missing values assuming there is no trend.Round seasonal indexes to 4 decimal places.Report Averages accurate to at most 2 decimal places.Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 92 93 95 106 Quarter 2 105 106 105 101 Quarter 3 197 187 196 1.5211 Quarter 4 106 116 121 0.8865 PART BSuppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5.Use seasonal indexes (rounded to 4 decimal places) from Part A.Report forecast answers as integers accurate to the nearest thousand.Quarter 1 forecast = thousandQuarter 2 forecast = thousandQuarter 3 forecast = thousandQuarter 4 forecast =…
Let’s suppose that you have a set of time-series variables, and you want to model the relationship between them. Read the situations given below and answer the questions. (200 words)a) Explain the statistical test if the linear combination (of time-series variables) is I(0).b) Which statistical test can be applied if all the series are integrated of the same order I(1). Justify your answer
What changes occur in the Coefficients of a Nonbasic Variable when the original model is modified?
Which of the three variables in Little's law do you believe is the most difficult to estimate in general (and why)?