(a) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand? (b) Use Goal Seek to calculate the price that results in breakeven. If required, round your answer to two decimal places. c) Use a data table that varies price from 350 to 3400 in increments of 325 to find the price that maximizes profit.

(a) Build a spreadsheet model to calculate the profit/loss for a given demand. What is the demand? (b) Use Goal Seek to calculate the price that results in breakeven. If required, round your answer to two decimal places. c) Use a data table that varies price from 350 to 3400 in increments of 325 to find the price that maximizes profit.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4E: Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total...

See similar textbooks

Similar questions

Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.
46. Revenue, cost, and profit. The price-demand equation and the cost function for the production of HDTVS are given, respectively, by x 9,000 - 30p and C(x) = 150,000 + 30x where x is the number of HDTVS that can be sold at a price of $p per TV and C(x) is the total cost (in dollars) of produc- ing x TVs.
Applying the DDM model utilizing the following inputs: PO, d1, d2, r, g. When rearranging the price expression so that we can solve for g, g= r - d2/((PO*(1+r)-d1)) True False
1. Call(35) = $9.12, Call(40) = $6.22, Call(45)= $4.08. Using MS Excel, create profit tables and graphs separately for each long call and then create a single chart showing profit for each long call on the same graph, clearly label each profit curve.
You are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price.= Answer ( Answer = "Yes" , Answer , Answer ) As an alternative, you could also use this logic to get the same results:When preferred status is No, the price is the regular price. Otherwise the price is the preferred price.= Answer ( Answer = "No" , Answer , Answer ) Note that these problems use short answer text boxes, and therefore can include any characters (not just numbers). Customer ID: 68YJW Prices: Regular $26.95 Customer Name Reggie Greene Preferred $21.95 Preferred? Y/N: Yes Customer Price
Build a spreadsheet model to calculate the profit/loss for a given demand. What profitcan be anticipated with a demand of 3500 copies?
A market demand function is given by the equation QD = 180 – 2P. Find the value of consumer surplus if price is equal to 65. Illustrate your demand curve and the area of consumer surplus. Identify the area of consumer surplus, the price at which demand is zero, the level of demand if price was zero and the slope (show calculation if required).
An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCosts
Company X tried selling widgets at various prices to see how much profit they would make. The following table shows the widget selling price, x, and the total profit earned at that price, y. Write a quadratic regression equation for this set of data, rounding all coefficients to the nearest tenth. Using this equation, find the profit, to the nearest dollar, for a selling price of 24.25 dollars. Price (x) Profit (y) 15.50 26727 18.50 36348 26.50 48488 35.75 54878 42.50 48488
The line that begins at the origin on a CVP graph represents total expenses. total fixed expenses. total sales revenues. both the total expenses and the total sales revenues. Which of the following best describes the concept of a "constraint?" Expected future costs that differ among alternatives. None of the items in this list of answers. A benefit foregone by choosing one alternative course over another. The distribution of all products to be sold.
For the ERPSim manufacturing game in SAP what should be the prices for 6 flavors of Museli and what should be the sales forecast and loan amount that needs to paid and what should be the amount to be paid for set up time and increasing production capacity? If possible, can you please add a template for loan and price calculator?
How much would be needed today to provide an annual amount of $50000 each year for 20 years, at 9% interest each year? a. $546,000 O b. $456,427 O c. $645,000 O d. $456,000