$\backslash$table$[[$Table A Metabical Demand Forecasts $(000\text{'}$s$)$ for four week count packages.$],[,,,,,,75,125,150,,,,],[$Method $1,$Year $1,$Year $2,$Year $3,$Year $4,$Year $5,$$$75$ Retail Price,Year $1($$$),$Year $2($$$),$Year $3($$$),$Year $4($$$),$Year $5($$$),$Cumulative$],[$Number of Americans with BMI between $25$ and $30,78,200,000,78,200,000,78,200,000,78,200,000,78,200,000,$Forecast Method $1,17,512,421,26,268,631,35,024,842,43,781,052,52,537,262,175,124,208],[\backslash$times $35\%$ actively trying to lose weight,$27,370,000,27,370,000,27,370,000,27,370,000,27,370,000,$Forecast Method $2,,,,,,],[$x$15\%$ who are comfortable using diet pills,$4105500\mathrm{.}00,4105500\mathrm{.}00,4105500\mathrm{.}00,4105500\mathrm{.}00,4105500\mathrm{.}00,$Forecast Method $3,,,,,,],[10\%$ who might purchase Metabocilin Year $1],[$adding $5\%$ each subsequent year,$410,550,615,825,821,100,1,026,375,1231650\mathrm{.}00,$$$125$ Retail Price,Year $1($$$),$Year $2($$$),$Year $3($$$),$Year $4($$$),$Year $5($$$),$Cumulative$],[$plus $60\%$ buy a second package,$246,330,369,495,492660\mathrm{.}00,615,825,738990\mathrm{.}00,$Forecast Method $1,41,048,267,61,572,400,82,096,534,102,620,667,123,144,801,410,482,670],[$plus $20\%$ of these buy a third package,$49,266,73,899,98532\mathrm{.}00,123,165,147798\mathrm{.}00,$Forecast Method $2,,,,,,],[$Sales$,706,146,1,059,219,1412292\mathrm{.}00,1765365\mathrm{.}00,2\mathrm{.}118\mathrm{.}438,$Forecast Method $3,,,,,,],[$Method $2],[$Number of Americans with BMI between $25$ and $30,78,200,000,78,200,000,78,200,000,78,200,000,78,200,000,$$$150$ Retail Price,Year $1($$$),$Year $2($$$),$Year $3($$$),$Year $4($$$),$Year $5($$$),$Cumulative$],[$x$12\%$ say they will go to a doctor to request prescription,$9384000\mathrm{.}00,9384000\mathrm{.}00,9384000\mathrm{.}00,9384000\mathrm{.}00,9384000\mathrm{.}00,$Forecast Method $1,52,819,721,79,229,581,105,639,442,132,049,302,158,459,162,528,197,208],[10\%$ who might purchase Metabocil Year $1,,,,,,$Forecast Method $2,,,,,,],[$adding $5\%$ each subsequent year,$938,400,1407600\mathrm{.}00,1,876,800,2346000\mathrm{.}00,2815200\mathrm{.}00,$Forecast Method $3,,,,,,],[$plus $60\%$ buy a second package,$563,040,844,560,1,126,080,1407600\mathrm{.}00,1689120\mathrm{.}00,,,,,,,],[$plus $20\%$ of these buy a third package,$112,608,168,912,225216\mathrm{.}00,281,520,337824\mathrm{.}00,,,,,,,],[$Sales$,1,614,048,2,421,072,3,228,096,$a$.$ Calculate the Gross Margin estimates for the first five years for the different price options and demand forecast scenarios $($use Table B in the next page as a guide; the demand forecasts are given to you in Table A below$).$

Table A Metabical Demand Forecasts $(000\text{'}$s$)$ for four week count packages.

Method $1$

Year $1$

Year $2$

Year $3$

Year $4$

Year $5$

Number of Americans with BMI between $25$ and $30$

$78,200,000$

$78,200,000$

$78,200,000$

$78,200,000$

$78,200,000$

x$35\%$ actively trying to lose weight

$27,370,000$

$27,370,000$

$27,370,000$

$27,370,000$

$27,370,000$

x$15\%$ who are comfortable using diet pills

$4,105,500$

$4,105,500$

$4,105,500$

$4,105,500$

$4,105,500$

$10\%$ who might purchase Metabocilin Year $1$

adding $5\%$ each subsequent year

$410,550$

$615,825$

$821,100$

$1,026,375$

$1,231,650$

Unit sales

plus $60\%$ buy a second package

$246,330$

$369,495$

$492,660$

$615,825$

$738,990$

Unit sales

plus $20\%$ of these buy a third package

$49,266$

$73,899$

$98,532$

$123,165$

$147,798$

Unit sales

Sales

$706,146$

$1,059,219$

$1,412,292$

$1,765,365$

$2\mathrm{.}118\mathrm{.}438$

Un

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

A key hospit al supplier, IVs Plus (IVP) located in Salina, KS sells IV tubing and stands to hospitals and clinics. Sales have picked up ever since they introduced their newest Squeaky Clean IV...

Q:

Applecore Children's Clothing is a retailer that sells high - end clothes for toddlers ( ages 1 to 3 ) , primarily in shopping malls. Applecore also has a successful Internet - based sales division....

Q:

Applecore Children's Clothing is a retailer that sells high - end clothes for toddlers ( ages 1 to 3 ) , primarily in shopping malls. Applecore also has a successful Internet - based sales division....

Q:

Applecore Children's Clothing is a retailer that sells high - end clothes for toddlers ( ages 1 to 3 ) , primarily in shopping malls. Applecore also has a successful Internet - based sales division....

Q:

1 Stanford Rosenberg Computing wants to establish an assembly line for producing a new product, the Personal Digital Assistant (PDA). The tasks, task times and immediate predecessors for the tasks...

Q:

Please write procedure Homework: Chapter 9 Layout Strategies Save Score: 0 of 1 pt 7 of 20 (0 complete) HW Score: 0%, 0 of 20 pts Problem 9.16 Question Help The following table details the tasks...

Q:

The following table details the tasks required for Indiana-based Frank Pianki Industries to manufacture a fully portable industrial vacuum cleaner. The times in the table are in minutes. Demand...

Q:

Calculate the demand (unit) forecast for the firsg 5 years for each of thr forecasting methids considered by Printup. Use table A in the next page as a guide (Method 1 calculations are completed for...

Q:

a . Calculate the Gross Margin estimates for the first five years for the different price options and demand forecast scenarios ( use Table B in the next page as a guide; the demand forecasts are...

Q:

a . Calculate the Gross Margin estimates for the first five years for the different price options and demand forecast scenarios ( use Table B in the next page as a guide; the demand forecasts are...

Q:

Medtech, Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market segments: a. General supermarket chains b. Drugstore chains c. Mom- and- pop single-...

Q:

The state evolution model allows us to model the relationship between the object state at the tth measurement and its state at the (t+1)th measurement. In particular, if the time difference At...

Q:

8. The following petty cash transactions of Grayson Golf Equipment occurred in May?:May 1: Established a petty cash fund with a $350 balance.May 31: The petty cash fund has $32 in cash and $310 in...

Q:

Inventory records for Herb's Chemicals revealed the following: March 1, 2021, inventory: 1,950 gallons @ $9.10 per gallon = $17,745 Purchases: Sales: Mar. 10 790 gals @ $ 9.15 Mar. 5 590 gals Mar. 16...

Previous Question Next Question