Assignment 1
Scottsville Textile Mill
As per the report a model has been developed which can be used to schedule production for the Scottsville Textile Mill and at the same time how many yards of each fabric must be purchased from another mill has been determined. All the discussion and analysis of the report has been included below.
Table 4.16
Monthly demand, selling price, variable cost, and purchase price data for Scottsville Textile Mill Fabrics Fabric | Demand (yards) | Selling price ($/yard) | Variable Cost ($/yard) | Purchase Price ($/yard) | 1 | 16500 | 0.99 | 0.66 | 0.80 | 2 | 22000 | 0.86 | 0.55 | 0.70 | 3 | 62000 | 1.10 | 0.49 | 0.60 | 4 | 7500 | 1.24 | 0.51 | 0.70 | 5 | 62000 | 0.70 | 0.50 | 0.70 |
Table
…show more content…
A discussion of the value of additional loom time. (The mill is considering purchasing a ninth dobbie loom. What is your estimate of the monthly profit contribution of this additional loom?)
If an additional dobbie loom is purchased, the total profit is $62998.19, an increase of $466.70. Depending on the cost of the loom, we should make sure whether is really necessary.
4. A discussion of the objective coefficients' ranges.
The following are range of variable cost
Cell | Name | Range | Fabric | 1 Dobbie | 0.65 | 0.68 | Fabric | 1 Regular | 0.52 | 1E+30 | Fabric | 2 Dobbie | -0.14 | 0.56 | Fabric | 2 Regular | 0.41 | 1E+30 | Fabric | 3 Dobbie | 0.48 | 1E+30 | Fabric | 3 Regular | 0.48 | 0.6 | Fabric | 4 Dobbie | 0.50 | 1E+30 | Fabric | 4 Regular | -0.11 | 0.52 | Fabric | 5 Dobbie | 0.48 | 1E+30 | Fabric | 5 Regular | -0.14 | 0.52 | Fabric | 1 y_i:=number of yard product i is purchased | 0.78 | 0.81 | Fabric | 2 y_i:=number of yard product i is purchased | 0.69 | 1E+30 | Fabric | 3 y_i:=number of yard product i is purchased | 0.49 | 0.61 | Fabric | 4 y_i:=number of yard product i is purchased | 0.62 | 1E+30 | Fabric | 5 y_i:=number of yard product i is purchased | 0.64 | 1E+30 |
There are no range of selling cost and purchasing cost, since the total selling profit only depends on the demands, which are
Q6: How much production fixed expenses should be allocated to 1 kg of "complete meal"? Give a specific number and your logic to support the
Breakeven Analysis for Product Tylenol Approach 1 - Same price as Tylenol Approach 2a - Cheaper than Tylenol Approach 2b - Cheaper w/lowered trade cost $ $ $ $ Unit Cost (Variable Cost) 0.60 0.60 0.60 0.60 Trade Cost (Selling Price to Retailers) $ 1.69 $ 1.69 $ 1.05 $ 0.70 Fixed Cost (Advertising) 2,000,000 6,000,000 6,000,000 6,000,000 Break-Even Quantity [Fixed Cost/(Trade Cost-Unit Cost)] 1,834,862 5,504,587 13,333,333 60,000,000 Contribution Margin (Unit) 64% 64% 43% 14%
1. Please assess the economic benefits of acquiring the Vulcan Mold-Maker machine. What is the initial outlay? What are the benefits over time? What is an appropriate discount rate? Does the net present value(NPV) warrant the investment in the machine?
2. a. According to the simulation spreadsheet, 4 hours of investment in creation maximizes daily profit at $371.33.
1. For financial accounting purposes, what is the total amount of product costs incurred to make 10,000 units?
B. 1. The impact of costs on the decision to move forward with the new Maui Sandal line is as follows: As the production continues, the hours needed for each batch, or individual pair, will begin to decrease. By continuing to produce this line the total labor costs will continue to decrease, but most likely, at a slower rate as more sandals are produced. This data can help the company decide employment levels, capacity, costs, and their pricing of this particular merchandise in the open market. The company predicts that it will take 1,000 labor hours for production to complete for the first batch, with 50 total batches between month 1 and month 4.
Mendel Paper Company has been doing relatively well with the sales of computer paper, napkins, place mats, and poster board. With more people eating out, the demand for napkins and place mats have increased. Computer paper and poster boards have slowly increased in demand as well. However, there is concern at the company with the fixed cost of operations. Marlene Herbert, the plant superintendent, said, “As we have automated our operation, we have experienced increases in fixed overhead and even variable overhead. And, we will have to add more equipment since it appears that we need even more plant capacity. We are operating over our normal capacity as it is.” (Case 2B). With the new production costs added in, will
Steve was concerned about the potential loss of customers and suggested that Prairie Winds purchase a second pasta production machine for $40 million. The company had excess space in the existing facility that could be used for the new machinery. However, this space currently was leased to another company on a year-to-year basis and was generating annual rent of
Q3. Do you agree with Mr. Clarkson’s estimation of the company loan requirements? How much will he need to finance the expected expansion in sales to $ 5.5 Mil. In 1996 and to take all trade discounts?
If Marlene Herbert were to discontinue place mats, he would miss $270,000 that will go toward Mendel paper company fixed cost. The company currently has a plant overhead that is estimated at $420,000 for the quarter. In addition to the fixed plant overhead, the plant incurs fixed selling and administrative expenses per quarter of $118,000. This draws the company to a total fixed cost of $538,000. If Marlene Herbert were to discontinue the second highest contributor to the fixed cost, he would need to increase the volume of computer paper and lower material cost to help pull the contribution margin of the lowest product up to help support the lost of a whole product line.
The Kenton Company processes unprocessed milk to produce two products, Butter Cream and Condensed Milk. The following information was collected for the month of June:
ML had developed a policy of selling manual machines and renting automatic machines. Manual machines did not cost much, did not require service, and could be modified to attach different fasteners inexpensively. Automatic machines were rented on an annual basis because they would have been more expensive to sell and it provided annual income to ML. However, about 700 of the rented machines were returned each year. During the time that machines were in inventory, ML would modify the machines to attach different fasteners. This was expensive with an average cost per modification of $2000. If all 700 machines were modified during a given year this would have cost $1.4 million per year. It was also industry practice to provide preventative maintenance and
First, we have identified if there is really an insufficiency in the amount of selling prices set by the Sales Department, in reference to Exhibit 1 of the case. We did this through identifying the maximum amount of overhead costs that the company can incur for the three products and comparing it with the total overhead costs. See Table 1 for details.
If the profit on sales revenue is 20% then profit on cost will become 25%(20%/80%)
cost-of-goods-sold section might be in relation to the sales total. In the case of a merchandising firm,