Question

In: Advanced Math

1. Southwest Clothing Company, produces denim jeans, is planning to introduce a new line of lime...

1. Southwest Clothing Company, produces denim jeans, is planning to introduce a new line of lime green jeans. Each pair of jeans costs $5.50 for fabric and $3.00 for labor. Each pair will be sold for $24.99 each. Fixed costs are estimated as $10,000 per month. Southwest intends to build an EXCEL model to explore the options for production.

a. Set up a spreadsheet model to calculate total profit with production quantity as the decision variable - assuming that Southwest will sell all of the jeans that are produced.

b. Use the Excel tool Data/What-If Analysis/Goal Seek to determine the break-even quantity for the jeans.

c. Use the Excel tool Data/What-If Analysis/Data Table to create a one-way table to demonstrate the sensitivity of profit to changes in selling price per pair of jeans

            Use prices of 21.99 23.99 25.99, 27.99 and 31.99 in your table.

d. Create a graph of the one-way table results.

Solutions

Expert Solution

(Dollars) (Dollars) (Dollars) (Dollars) (Dollars) (Dollars)
Price (Per Unit) 24.99 21.99 23.99 25.99 27.99 31.99
Units Sold 606.4281 606.4281 606.4281 606.4281 606.4281 606.4281
Total Revenue 15154.64 13335.35 14548.21 15761.07 16973.92 19399.64
Fixed Cost 10000 10000 10000 10000 10000 10000
Fabric Cost (Per Unit) 5.5 5.5 5.5 5.5 5.5 5.5
Labor Cost (Per Unit) 3 3 3 3 3 3
Cost (Per Unit) 8.5 8.5 8.5 8.5 8.5 8.5
Total Cost 15154.64 15154.64 15154.64 15154.64 15154.64 15154.64
Profit 0 -1819.28 -606.428 606.4281 1819.284 4244.997

Price (Per Unit) Profit (606.4281 units sold)
21.99 -1819.284415
23.99 -606.4281383
24.99 0
25.99 606.4281383
27.99 1819.284415
31.99 4244.996968   

Related Solutions

You have a company that manufactures denim jeans and denim jackets.   A denim jeans costs 5$...
You have a company that manufactures denim jeans and denim jackets.   A denim jeans costs 5$ to make and uses 2 yards of denim. You sell the denim jeans for $25.00 A denim jacket costs 12$ to make and uses 3 yards of denim. You sell the denim jacket for $40.00. You have 300 yards of denim. You need to sell at least 10 jeans and 10 jackets in a year. How many jeans and jackets would you have to...
Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters as part...
Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters as part of the winter collection for $65 with an inventory of 1500. The main selling season is 60 days between November and December. The store then sells the remaining units in a clearance sale at 65 percent discount. Out of the 60 main retail days, Fiberia sells the sweaters at full retail price for only 45 days, while giving a discount of 25 percent for...
Burlington Mills produces denim cloth that it sells to jeans manufacturers. It is negotiating a new...
Burlington Mills produces denim cloth that it sells to jeans manufacturers. It is negotiating a new contract to provide cloth on a weekly basis to BJ Jeans. The demand for cloth from BJ Jeans is expected to vary each week according the following discrete probability distribution: Demand (yd) 0 0.05 100 0.15 200 0.40 300 0.30 400 0.10 Burlington’s plant capacity available for this new job will vary each week because of other commitments and occasional breakdowns. Burlington estimates that...
Bonnie Denim Company sells blue jeans. Last year, skinny jeans were fashionable;
Bonnie Denim Company sells blue jeans. Last year, skinny jeans were fashionable; this year, relaxed-fit jeans are in style. The company has 415 units of skinny jeans with a cost of $19 per unit and a market value of $17 per unit. The inventory also includes 1,040 units of relaxed-fit jeans with a cost of $18 per unit and a market value of $21 per unit. Required: Prepare the journal entry, if any, that is required to adjust the Inventory...
Helen Croker owns Divine Denim, a growing company making made to measure, designer denim jeans and...
Helen Croker owns Divine Denim, a growing company making made to measure, designer denim jeans and jackets. She uses organic yarn-dyed cotton denim of different weights depending on the garment that she is making. Although she prefers to take the measurements herself, she is now making denim clothes for international customers using the self-measuring system she has developed and put online. For her custom clients, she takes measurements or uses the measurements supplied through her customers’ online application. She uses...
A group of your friends from college are planning to start a clothing line company. They...
A group of your friends from college are planning to start a clothing line company. They are in the process of writing their vision statement, mission statement, and values statement. They come to you for examples of companies’ statements you feel they could model theirs from. You offer to give them advice. Write a professional 1-page (300-350 word) email addressing the following areas: A company that has an ideal vision statement. Be sure to include the vision statement and explain...
. An automobile company is ready to introduce a new line of hybrid cars through a...
. An automobile company is ready to introduce a new line of hybrid cars through a national sales campaign. After test marketing the line in a carefully selected city, the marketing research department estimates that sales (in millions of Ghana Cedis) will increase at the monthly rate of S'(t) = 20t − 15e−0.15t 0 ≤ t ≤ 36 t months after the campaign has started. (a) What will be the total sales S(t) in t months after the beginning of...
You work in a manufacturing company which produces white goods. The company is planning an investment in a new product line.
  You work in a manufacturing company which produces white goods. The company is planning an investment in a new product line. The initial investment includes the machinery required for the production line which costs $320,000. Other expenses were included in the expected cash flows. The new machinery has a useful life of 4 years and an estimated residual value at the end of the 4th year of $80,000. Depreciation is the only non-cash expense. The net cash flows of...
Hereford Company is planning to introduce a new product with an 80 percent learning rate for...
Hereford Company is planning to introduce a new product with an 80 percent learning rate for production for batches of 1,000 units. The variable labor costs are $30 per unit for the first 1,000-unit batch. Each batch requires 100 hours. There are $10,000 in fixed costs not subject to learning. What is the cumulative total time using the incremental unit-time learning curve to produce 2,000 units? Select one: a. 180 b. 100 c. 90 d. 80
Cortez Company is planning to introduce a new product that will sell for $106 per unit....
Cortez Company is planning to introduce a new product that will sell for $106 per unit. The following manufacturing cost estimates have been made on 20,000 units to be produced the first year: Direct materials $ 800,000 Direct labor 480,000 (= $16 per hour × 30,000 hours) Manufacturing overhead costs have not yet been estimated for the new product, but monthly data on total production and overhead costs for the past 24 months have been analyzed using simple linear regression....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT