Q: This question refers to the spreadsheet that we used in our lectures to analyze a New Product Venture. This spreadsheet is titled MODULE 4 – NEW PRODUCT VENTURE – BASE CASE.xls Re-set everything in the spreadsheet. In particular, make sure that the tax rate is 40% and the initial sales volume is 2000. Check that everything is correctly reset…
-
-
This question refers to the spreadsheet that we used in our lectures to analyze a New Product Venture. This spreadsheet is titled MODULE 4 – NEW PRODUCT VENTURE – BASE CASE.xls Re-set everything in the spreadsheet. In particular, make sure that the tax rate is 40%, the initial sales volume is 2000, and the R&D costs are $20,000 in years 1 and 2. Check that everything is correctly reset by making sure the NPV = $26,624 and the IRR = 11.5%. Suppose we offer to let customers pay later in the hope that it stimulates more sales. Specifically, suppose customers only pay 80% of the purchase price in the year of the sale (and 20 percent the next year), but that this increases Sales volume per year to 2300 units. What is new Net Present Value of the proposed new product venture?
Q: This question refers to the spreadsheet that we used in our lectures to analyze a New Product Venture. This spreadsheet is titled MODULE 4 – NEW PRODUCT VENTURE – BASE CASE.xls Re-set everything in the spreadsheet. In particular, make sure that the tax rate is 40%, the initial sales volume is 2000, and the R&D costs are $20,000 in…
-
Which of the following are on a Balance Sheet? (there can be more than one)
Q: Which of the following are on a Balance Sheet? (there can be more than one) or Q: Which of the following are on a Balance Sheet? (more than one may exist.) Retained Earnings Accounts Payable Depreciation Expense Cash Sales Revenue Explanation: This represents the accumulated earnings of a company that have not been distributed to shareholders as dividends. This…
-
Which of the following are on an Income Statement? (there can be more than one)
Q: Which of the following are on an Income Statement? (there can be more than one) or Q: On an income statement, which of the following is true? (more than one may exist.) Cost of Goods Sold Retained Earnings Interest Expense Selling, General, and Administrative Expense Explanation: This reflects the direct costs of producing the goods that a company sells.…
-
The spreadsheet below models the costs and potential revenues of manufacturing speakers, assuming that the full order is sold. In the spreadsheet, four different sets of cells have been designated as A, B, C, and D. Assume there is an expedited manufacturing option that results in a 50% reduction in time for customers to receive their goods. However, that expedited service increases the cost of the order by 25%. Which designated set of cells is the logical place to insert that potential 25% cost increase as a variable?
Q: The spreadsheet below models the costs and potential revenues of manufacturing speakers, assuming that the full order is sold. In the spreadsheet, four different sets of cells have been designated as A, B, C, and D. Assume there is an expedited manufacturing option that results in a 50% reduction in time for customers to receive their goods. However, that…
-
Refer again to the spreadsheet in Q2. Again, assume there is an expedited manufacturing option that results in a 50% reduction in time for customers to receive their goods, but that expedited service increases the cost of the order by 25%. Which designated set of cells is the logical place to insert a yes/no variable to indicate that the order is to be expedited?
Q: Refer again to the spreadsheet in Q2. Again, assume there is an expedited manufacturing option that results in a 50% reduction in time for customers to receive their goods, but that expedited service increases the cost of the order by 25%. Which designated set of cells is the logical place to insert a yes/no variable to indicate that the…
-
Refer again to the spreadsheet in Q2. If we wanted to add a variable to this model to calculate average unit cost as an important output to monitor, which designated set of cells is the logical place to insert that output?
Q: Refer again to the spreadsheet in Q2. If we wanted to add a variable to this model to calculate average unit cost as an important output to monitor, which designated set of cells is the logical place to insert that output? or Q: Consult the Q2 spreadsheet once again. Which specific cell set would be the most sensible location…
-
Refer again to the spreadsheet in Q2, and assume that the following range names have been created: number_ordered (cell B5); discount51 (cell B11); discount101 (cell B12); and cost_per_cabinet (cell B15). What is a formula for cell B16 that would use these range names?
Q: Refer again to the spreadsheet in Q2, and assume that the following range names have been created: number_ordered (cell B5); discount51 (cell B11); discount101 (cell B12); and cost_per_cabinet (cell B15). What is a formula for cell B16 that would use these range names? or Q: Assume that the range names number_ordered (cell B5), discount51 (cell B11), discount101 (column B12),…
-
What is a useful source of data for projections and forecasts, such as sales forecasts or costs of goods sold?
Q: What is a useful source of data for projections and forecasts, such as sales forecasts or costs of goods sold? or Q: What is a decent place to find information for predictions and estimates, such sales projections or expenses of products sold? Your own competitive market research Your own historical data Public corporations’ operating data Data from market research…
-
Assume that you have a company that assembles final products from a large variety of components that are supplied by factories located in various parts of the world. In the past you have experienced disruptions in the flow of your supply of components as the result of bad weather, such as a strong El Niño phenomenon, as well as other uncontrollable events. You have back-up suppliers, but each have different capacities and delivery schedules. So you created a model that includes sets of assumptions about changes in suppliers and delivery times in the event of unusual disruptive events. The Excel tool specifically designed for your use in this case is:
Q: Assume that you have a company that assembles final products from a large variety of components that are supplied by factories located in various parts of the world. In the past you have experienced disruptions in the flow of your supply of components as the result of bad weather, such as a strong El Niño phenomenon, as well as…