|
Sensitivity Report |
|||||
|
Name |
Final Value |
Reduced Cost |
Objective Coefficient |
Allowable Increase |
Allowable Decrease |
|
# Aqua-Spa |
110 |
0 |
350 |
80 |
30 |
|
# Hydro-Lux |
0 |
-20 |
300 |
20 |
Infinite |
|
# Typhoon-Lagoon |
75 |
0 |
320 |
50 |
10 |
|
Constraints |
|||||
|
Name |
Final Value |
Shadow Price |
Constant RHS |
Allowable Increase |
Allowable Decrease |
|
# Pumps used |
175 |
150 |
175 |
10 |
15 |
|
Hrs. Labor Used |
1400 |
0 |
1500 |
Infinite |
125 |
|
Ft. of Tubing Used |
2550 |
7 |
2550 |
100 |
50 |
(a)What is the optimal decision? What is the value of the profit if this decision is implemented?
(b) What is the allowable set of values that the objective function coefficient of x3 can range over? How should this range be interpreted? Choose a value in that range, and calculate the value of the profit for that value.
(c) How much of each resource is being consumed to produce the optimal solution?
(d) What is the meaning of the shadow price for tubing?
(e) Why is the shadow price for labor equal to zero?
(f) What is the meaning of the reduced cost for Hydro-Luxes?
In: Operations Management
Part II Content of Marketing Plan As a marketer
, you will need a good marketing plan to provide direction and focus for your brand, product, or company. To deeper understand what to write in the marketing plan, one essential step is to know competitive advantage through well-informed segmenting, targeting, differentiating, and positioning decisions. Pay attention that unlike a business plan, a marketing plan has a more limited scope. It serves to document how the organization’s strategic objectives will be achieved through specific marketing strategies and tactics, with the customer as the starting point. Also, to develop successful strategies and action programs, marketers require up-to-date information about the environment, the competition, and the market segments to be served. Scenario: you are running a hypothetical start-up company – Link. The company’s first product is the Link H One, a multimedia, cellular/Wi-Fi-enabled smartphone. Link will be competing with Apple, Samsung, Huawei, HTC and other well-established rivals in a crowded, fast changing marketplace for smartphones that combine communication, entertainment, and storage functionality. Link is preparing to launch Link H One in a mature market. This product offers a competitive unique combination of advanced features and functionality at a value-added price. The company plans to target specific segments in the consumer and business markets, taking advantage of opportunities indicated by higher demand for easy-to-use smartphones with expanded communications, entertainment, and storage functionality. The primary marketing objective is to achieve first-year U.S sale of 500,000 units. The primary financial objectives are to achieve first-year sales revenues of $75 million, keep first-year losses under $8 million, and break even early in the second year.
In: Accounting
Blossom, Inc., is a small company that manufactures three
versions of patio tables. Unit information for its products
follows:
| Table A | Table B | Table C | |||||||
| Sales price | $ | 55 | $ | 59 | $ | 73 | |||
| Direct materials | 11 | 12 | 13 | ||||||
| Direct labor | 3 | 5 | 9 | ||||||
| Variable manufacturing overhead | 5 | 5 | 5 | ||||||
| Fixed manufacturing overhead | 8 | 8 | 8 | ||||||
| Required number of labor hours | 0.5 | 0.5 | 1.0 | ||||||
| Required number of machine hours | 4.0 | 2.50 | 2.0 | ||||||
Blossom has determined that it can sell a limited number of each
table in the upcoming year. Expected demand for each model
follows:
| Table A | 60,000 | units | |
| Table B | 20,000 | units | |
| Table C | 20,000 | units | |
Required:
1. Suppose that direct labor hours has been identified as
the bottleneck resource. Determine how Blossom should prioritize
production by rank ordering the products from 1 to 3.
2. If Blossom has only 50,000 direct labor hours
available, calculate the number of units of each table that Blossom
should produce to maximize its profit. (Enter the products
in the sequence of their preferences; the product with first
preference should be entered first.)
3. Suppose that the number of machine hours has
been identified as the most constrained resource. Determine how
Blossom should prioritize production by rank ordering the products
from 1 to 3.
4. If Blossom has only 247,000 machine hours
available, calculate the number of units of each table that Blossom
should produce to maximize its profit. (Enter the products
in the sequence of their preferences; the product with first
preference should be entered first.)
In: Accounting
Problem 9-4
Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011:
| January | February | March | April | |
| Sales (units) | 35,000 | 31,000 | 38,000 | 29,000 |
Each unit requires three hours of direct labor.
Additional information:
Karam sells each unit for $95.
Company policy is to have 30 percent of next month's sales (in
units) in ending finished goods inventory.
Company policy is to have 40 percent of next month's production
needs in ending raw materials inventory. The production needs for
April is 95,500.
It takes three pounds of material to produce each unit and the cost
is $2.75/pound.
Required:
A. Prepare a sales budget for the January, February and March and for the first quarter in total.
| Karam Inc. | ||||
| Sales Budget | ||||
| For the Quarter Ended March 31, 2011 | ||||
| January | February | March | Total | |
| Sales in units | ||||
| Unit selling price | $ | $ | $ | $ |
| Budgeted sales | $ | $ | $ | $ |
B. Prepare a production budget for January, February and March and for the first quarter in total.
| Karam Inc. | ||||
| Production Budget | ||||
| For the Quarter Ended March, 31, 2011 | ||||
| January | February | March | Total | |
| Sales in units (given) | ||||
| Desired ending inventory | ||||
| Total needs | ||||
| Less: Beginning inventory | ||||
| Units to be produced | ||||
C. Prepare a direct materials purchases budget for January, February and March and for the first quarter in total.
| Karam Inc. | ||||
| Production Budget | ||||
| For the Quarter Ended March 31, 2011 | ||||
| January | February | March | Total | |
| Units to be produced | ||||
| Direct materials per unit | ||||
| Production needs | ||||
| Desired ending inventory | ||||
| Total needs | ||||
| Less: Beginning inventory | ||||
| Direct materials to be purchased | ||||
| Cost per pound | $ | $ | $ | $ |
| Total purchase cost | $ | $ | $ | $ |
In: Accounting
Bakersfield Company makes and sells glare filters for microcomputer monitors. Steve Smith, the controller, is responsible for preparing Bakersfield’s master budget and assembled the following data for the upcoming year. The direct materials cost per unit was $18 in December of the current year. Labor saving machinery will be operational by March of the upcoming year. Also, as of March 1, the company plans to increase its direct labor rate. Direct labor for Bakersfield is considered variable because the company can call in its workers when needed and send them home when not needed. Bakersfield expects to have 5,600 filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following month’s projected sales in inventory. Information for the first four months of the upcoming year is as follows:
|
January |
February |
March |
April |
|
|
Estimated unit sales |
36,000 |
34,500 |
39,000 |
38,600 |
|
Sales price per unit |
$160 |
$160 |
$150 |
$150 |
|
Direct labor hours per unit |
3.0 |
3.0 |
2.5 |
2.5 |
|
Direct labor rate per hour |
$36 |
$36 |
$40 |
$40 |
|
Direct materials cost per unit |
$18 |
$18 |
$18 |
$18 |
Requirements:
Prepare the following budgets for Bakersfield Company for each month in the first quarter (January through March) and for the entire first quarter of the upcoming year. Show supporting calculations.
Production budget
Direct labor cost budget
Direct materials usage budget in dollars
Sales revenue budget
Calculate the total budgeted contribution margin for Bakersfield by month (months of January through March) and in total for the first quarter of the upcoming year. Show supporting computations.
In: Accounting
Blossom, Inc., is a
small company that manufactures three versions of patio tables.
Unit information for its products
follows:
| Table A | Table B | Table C | |||||||
| Sales price | $ | 40 | $ | 44 | $ | 58 | |||
| Direct materials | 6 | 7 | 8 | ||||||
| Direct labor | 1 | 3 | 7 | ||||||
| Variable manufacturing overhead | 2 | 2 | 2 | ||||||
| Fixed manufacturing overhead | 5 | 5 | 5 | ||||||
| Required number of labor hours | 0.5 | 0.5 | 1.0 | ||||||
| Required number of machine hours | 4.0 | 2.50 | 2.0 | ||||||
Blossom has determined that it can sell a limited number of each
table in the upcoming year. Expected demand for each model
follows:
| Table A | 50,000 | units | |
| Table B | 20,000 | units | |
| Table C | 30,000 | units | |
Required:
1. Suppose that direct labor hours has been identified as
the bottleneck resource. Determine how Blossom should prioritize
production by rank ordering the products from 1 to 3.
2. If Blossom has only 40,000 direct labor hours
available, calculate the number of units of each table that Blossom
should produce to maximize its profit. (Enter the products
in the sequence of their preferences; the product with first
preference should be entered first.)
3. Suppose that the number of machine hours has
been identified as the most constrained resource. Determine how
Blossom should prioritize production by rank ordering the products
from 1 to 3.
4. If Blossom has only 232,000 machine hours
available, calculate the number of units of each table that Blossom
should produce to maximize its profit. (Enter the products
in the sequence of their preferences; the product with first
preference should be entered first.)
In: Accounting
1. Kirkland Company provided the following information for the month ended July 31, 2015, based on selling 1,000 units of its bottled water.
|
Sales Revenue |
$800,000 |
|
Variable Costs |
$300,000 |
|
Fixed Costs |
$100,000 |
What is Kirkland's margin of safety?
2. Chutes Company sells slides for $400 each. If their fixed costs total $300,000, how many slides must Chutes sell to breakeven if variable costs are $100 each?
3. Chutes Company sells slides for $400 each. If their fixed costs total $300,000, how much in sales revenue must Chutes achieve to breakeven if variable costs are $100 each?
4. Chutes Company sells slides for $400 each. If their fixed costs total $300,000, how many slides must Chutes sell to reach a target net income of $800,000 if variable costs are $100 each?
5. Chutes Company sells slides for $400 each. If their fixed costs total $300,000, how much in sales revenue must Chutes achieve to reach a target net income of $800,00 if variable costs are $100 each?
6. Chutes Company sells slides for $400 each. If their fixed costs total $300,000, what is the margin of safety ratio if chutes expects to achieve a net income of $800,000 when variable cost are $100 each?
7. A company sells a product which has a unit sales price of $10, unit variable cost of $2 and total fixed costs of $135,000. How many units must the company must sell to break even?
8. For Clifford Company, sales are $2,000,000 for the one product they sell. Fixed expenses are $700,000 and the contribution margin ratio is 40%. What are required sales in dollars to earn a target net income of $400,000?
9. Madden Company produces dongles for computers, which it sells for $20 each. Each dongle cost $4 of variable costs to make. During June, 4,000 dongles were sold. Fixed costs for May were $5 per unit for a total of $20,000 for the month. How much is the contribution margin ratio?
10. Based on the chart below, classify each of the costs ar variable, fixed or mixed. State how you came to your conclusion.
|
Cost |
Month |
Cost |
Units Produced |
|
Drilling Costs |
January February |
$80,000 $120,000 |
40,000 60,000 |
|
Smoothing Costs |
January February |
$100,000 $100,000 |
70,000 60,000 |
|
Mining Costs |
January February |
$159,000 $195,000 |
43,000 55,000 |
a. Drilling Costs
b. Smoothing Costs
c. Mining Costs
In: Accounting
This Excel file DI Basketball Graduation Rates shows the graduation rates for the men's and women's basketball teams that participated in recent NCAA division I men's and women's basketball tournaments. There are data for 67 men's teams and 63 women's teams since Princeton had teams in both tournaments but does not report graduation rates. Use the data to calculate a 90% confidence interval for ?M - ?F, the difference in the mean graduation rates for all division I men's and women's basketball teams. Do not waste time entering this data into a graphing calculator! Use Excel or Statcrunch! Use 2 decimal places in your answers. lower bound of confidence interval upper bound of confidence interval Select the choice below that correctly interprets the confidence interval. Since the interval is entirely negative, it appears that their is no significant difference between the DI women's basketball mean graduation rate and the DI men's basketball mean graduation rate. Since the interval contains zero we can conclude that both graduation rates are too low. Since the interval is entirely positive it appears that both men's and women's mean basketball graduation rates are higher than the graduation rate for the general student body. Since the interval is entirely negative, it appears that the DI men's basketball mean graduation rate is higher than the DI women's basketball mean graduation rate. Since the interval is entirely negative, it appears that the DI women's basketball mean graduation rate is higher than the DI men's basketball mean graduation rate.
| NCAA Basketball Tournament Graduation Success Rate (GSR) of Participating* Men's and Women's Teams | ||
| * 67 men's teams and 63 women's teams since Princeton does not report graduation rates | ||
| School | Men/Women | Graduation Rate |
| Akron | men | 38 |
| Alabama State | men | 63 |
| Arizona | men | 20 |
| Arkansas-Little Rock | men | 92 |
| Belmont | men | 100 |
| Boston | men | 90 |
| Bucknell | men | 91 |
| Butler | men | 83 |
| BYU | men | 100 |
| Cincinnati | men | 53 |
| Clemson | men | 71 |
| Connecticut | men | 31 |
| Duke | men | 83 |
| Florida | men | 44 |
| Florida State | men | 73 |
| George Mason | men | 67 |
| Georgetown | men | 78 |
| Georgia | men | 36 |
| Gonzaga | men | 73 |
| Hampton | men | 67 |
| Illinois | men | 100 |
| Inidiana State | men | 67 |
| Kansas | men | 80 |
| Kansas State | men | 40 |
| Kentucky | men | 44 |
| Long Island | men | 78 |
| Louisville | men | 50 |
| Marquette | men | 91 |
| Memphis | men | 58 |
| Michigan | men | 36 |
| Michigan State | men | 50 |
| Missouri | men | 44 |
| Morehead State | men | 43 |
| North Carolina | men | 88 |
| Northern Colorado | men | 77 |
| Notre Dame | men | 100 |
| Oakland | men | 75 |
| Ohio State | men | 64 |
| Old Dominion | men | 63 |
| Penn State | men | 86 |
| Pittsburgh | men | 64 |
| Purdue | men | 67 |
| Richmond | men | 83 |
| San Diego State | men | 58 |
| St. John's | men | 70 |
| St. Peter's College | men | 70 |
| Syracuse | men | 54 |
| Temple | men | 33 |
| Tennessee | men | 40 |
| Texas | men | 42 |
| Texas A&M | men | 64 |
| UAB | men | 25 |
| UC Santa Barbara | men | 77 |
| UCLA | men | 70 |
| UNC Asheville | men | 50 |
| UNLV | men | 67 |
| USC | men | 42 |
| UT San Anotonio | men | 50 |
| Utah State | men | 100 |
| Vanderbilt | men | 93 |
| VCU | men | 56 |
| Villanova | men | 100 |
| Washington | men | 44 |
| West Virginia | men | 71 |
| Wisconsin | men | 70 |
| Wofford | men | 100 |
| Xavier | men | 92 |
| Arizona State | women | 92 |
| Baylor | women | 88 |
| Bowling Green | women | 100 |
| California State, Fresno | women | 80 |
| California, Davis | women | 86 |
| Connecticut | women | 92 |
| Dayton | women | 100 |
| DePau | women | 92 |
| Duke | women | 100 |
| Florida State | women | 77 |
| Gardner-Webb | women | 100 |
| Georgetown | women | 91 |
| Georgia | women | 77 |
| Georgia Tech | women | 77 |
| Gonzaga | women | 94 |
| Green Bay | women | 92 |
| Hampton | women | 50 |
| Houston | women | 78 |
| Iowa | women | 100 |
| Iowa State | women | 100 |
| James Madison | women | 71 |
| Kansas State | women | 92 |
| Kentucky | women | 91 |
| Louisiana Tech | women | 56 |
| Louisville | women | 93 |
| Marist | women | 100 |
| Marquette | women | 92 |
| Maryland | women | 67 |
| McNeese State | women | 81 |
| Miami | women | 100 |
| Michigan State | women | 77 |
| Middle Tennessee | women | 85 |
| Montana | women | 83 |
| Navy | women | 94 |
| North Carolina | women | 100 |
| Northern Iowa | women | 10 |
| Notre Dame | women | 100 |
| Ohio State | women | 100 |
| Oklahoma | women | 92 |
| Penn State | women | 100 |
| Prairie View A&M | women | 57 |
| Purdue | women | 71 |
| Rutgers | women | 90 |
| Samford University | women | 100 |
| South Dakota State | women | 100 |
| St. Francis (PA) | women | 100 |
| St. John's | women | 100 |
| Stanford | women | 100 |
| Stetson | women | 67 |
| Temple | women | 71 |
| Tennessee | women | 100 |
| Tennessee, Martin | women | 86 |
| Texas | women | 79 |
| Texas | women | 65 |
| Texas Tech | women | 100 |
| UALR | women | 89 |
| UCF | women | 94 |
| UCLA | women | 93 |
| University of Hartford | women | 100 |
| University of Utah | women | 83 |
| Vanderbilt | women | 100 |
| West Virginia | women | 70 |
| Xavier | women | 100 |
In: Statistics and Probability
Periodic Inventory by Three Methods; Cost of Merchandise Sold
The units of an item available for sale during the year were as follows:
| Jan. 1 | Inventory | 50 units @ $110 |
| Mar. 10 | Purchase | 60 units @ $122 |
| Aug. 30 | Purchase | 20 units @ $130 |
| Dec. 12 | Purchase | 70 units @ $134 |
There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used.
Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar.
| Cost of Merchandise Inventory and Cost of Merchandise Sold | ||
| Inventory Method | Merchandise Inventory | Merchandise Sold |
| First-in, first-out (FIFO) | $ | $ |
| Last-in, first-out (LIFO) | ||
| Weighted average cost | ||
Note that this exercise uses the periodic inventory system. FIFO means that the first units purchased are assumed to be the first to be sold. Therefore, ending inventory costs for the period are calculated by taking the number of items remaining in the physical inventory times the most recent purchase price. If the number of items in last purchase layer is less than the number in ending inventory, the balance of the ending inventory items must be recorded at the second most recent purchase cost. The cost of merchandise sold for the period can be calculated by subtracting the ending inventory from the total cost of goods available for sale.
Note that this exercise uses the periodic inventory system. LIFO means the last units purchased are assumed to be the first to be sold. Therefore the ending inventory for the period is made up of the earliest costs from the period (the beginning inventory). If the number of units in the ending inventory is greater than the units in the beginning inventory, the excess units will be recorded at the next oldest cost associated with the first purchase. The cost of merchandise sold for the period can be calculated by subtracting the ending inventory from the total cost of goods available for sale.
Note that this exercise uses the periodic inventory system. Average unit cost means the average unit cost of all available units purchased is applied to the number of units sold and those in ending inventory. Therefore, you must first obtain a unit cost by dividing the total cost of all units available for sale by the number of units available for sale. Then multiply the number of items remaining in the physical inventory times this unit cost. The cost of merchandise sold for the period can be calculated by subtracting the ending inventory from the total cost of goods available for sale.
In: Accounting
| XYZ stock price and dividend history are as follows: |
| Year | Beginning-of-Year Price | Dividend Paid at Year-End |
| 2010 | $ 124 | $ 4 |
| 2011 | $ 135 | $ 4 |
| 2012 | $ 115 | $ 4 |
| 2013 | $ 120 | $ 4 |
|
An investor buys six shares of XYZ at the beginning of 2010, buys another two shares at the beginning of 2011, sells one share at the beginning of 2012, and sells all seven remaining shares at the beginning of 2013. |
What is the arithmetic average time-weighted rates of return for the investor? (Do not round intermediate
calculations. Enter your answer as a decimal number rounded to four decimal places)
Arithmetic average time-weighted rates of return?
In: Finance