Question

Cox Electric makes electronic components and has estimated the following for a new design of one...

Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $9,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 Production Volume = 12,000 (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur? (b) Use Goal Seek to find the exact breakeven point. Assign Set cell: equal to the location of profit, To value: = 0, and By changing cell: equal to the location of the production volume in your model.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cox Electric makes electronic components and has estimated the following for a new design of one...
Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed Cost = $11,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 Production Volume = 12,000 Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build a spreadsheet model that calculates the profit by subtracting the fixed cost and total...
QUESTION 5 CVP Analysis Guide to marks: 20 marks - 8 for (a), 6 for (b),...
QUESTION 5 CVP Analysis Guide to marks: 20 marks - 8 for (a), 6 for (b), 6 for (c) We start with a simple use of Excel in CVP analysis. Copy this model into Excel: A B 1 Known parameters 2 Selling price per unit 10 3 Fixed cost 1000 4 Variable cost per unit 5 5 6 Variables 7 Number of units X 1000 8 9 Results 10 Total revenue =B2*B7 11 Fixed cost =B3 12 Total variable costs...
Hi guys, could you tell me what else can I add to this Discussion Post? It's...
Hi guys, could you tell me what else can I add to this Discussion Post? It's not mine, I'm just replying!! --- Fixed costs are costs that remain the same in total regardless of changes in the activity level. Examples would include property taxes, insurance, rent, deprecation, etc. Because the total fixed costs remain constant as activity changes, it follows that fixed costs per unit vary inversely with activity so as volume increases, unit costs decline and vice versa (Kimmel...
4. A company that makes optical computer input devices has calculated their revenue and costs as...
4. A company that makes optical computer input devices has calculated their revenue and costs as follows for the most recent fiscal period: Sales ​$522 000 Costs: ​Fixed Costs​ $145 000 ​Variable Costs ​208 800 Total Costs ​353 800 Net Income ​$168 200 ​What is the break-even point in sales dollars? 5. A company that makes environmental measuring devices has calculated their revenue and costs as follows for the most recent fiscal period: Sales ​$750 000 Costs: ​Fixed Costs​ $200...
Which of the following did Queen Elizabeth of England create in 1600 by granting a charter...
Which of the following did Queen Elizabeth of England create in 1600 by granting a charter to the East India Company, bestowing exclusive trading rights in India? a. An (old-fashioned) technological innovation b. A price-discriminating monopoly c. A legal barrier to entry d. A natural barrier to entry The single-price monopolist sets price at which of the following points? a. At the point where demand equal marginal cost b. At the point on the demand curve directly above the point...
In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called...
In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called The Dougie that teaches children how to dance. The fixed cost to produce the doll is $100,000. The variable cost, which includes material, labor, and shipping costs, is $34 per doll. During the holiday selling season, FTC will sell the dolls for $42 each. If FTC overproduces the dolls, the excess dolls will be sold in January through a distributor who has agreed to...
1.) Weightless Inc. produces a small and large version of its popular electronic scale. The anticipated...
1.) Weightless Inc. produces a small and large version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows: Bath Scale Gym Scale East Region unit sales 23,600 38,900 West Region unit sales 25,500 26,800 Total 49,100 65,700 The finished goods inventory estimated for October 1 for the Bath and Gym scale models is 1,500 and 2,000 units, respectively. The desired finished goods inventory for October 31 for the Bath and Gym...
Which of the following statements is true about profit, revenue and cost? A. In economics, π...
Which of the following statements is true about profit, revenue and cost? A. In economics, π means “profit”. B. Profit equals to revenue minus cost. C. π = R – C D. All above are true. 0.4 points    QUESTION 2 The relationship between quantity of input and total quantity of output is _____________ A. Production function. B. Total cost function. C. Total revenue curve. D. Marginal production curve. 0.4 points    QUESTION 3 Which of the following statements is...
A division in XYZ Co. had the following financial data for 2019: sales $500,000, average operating...
A division in XYZ Co. had the following financial data for 2019: sales $500,000, average operating assets $200,000, margin (or profit margin) 4%, minimum required rate of return 8%. What was the return on investment for the division? A. 10%. B. 20%. C. 16%. D. 12%. Patricia’s housekeeping company has the following data projected for June. Beginning cash balance $24,500 Cash collections from customers 36,200 Cash disbursements 54,300 Patricia wants to maintain a cash balance of $10,000 or more. Any...
Special Order Total cost data follow for Greenfield Manufacturing Company, which has a normal capacity per...
Special Order Total cost data follow for Greenfield Manufacturing Company, which has a normal capacity per period of 20,000 units of product that sell for $54 each. For the foreseeable future, regular sales volume should continue to equal normal capacity. Direct material $268,800 Direct labor 202,000 Variable manufacturing overhead 154,000 Fixed manufacturing overhead (Note 1) 118,800 Selling expense (Note 2) 129,600 Administrative expense (fixed) 50,000 $923,200 Notes: 1. Beyond normal capacity, fixed overhead costs increase $4,500 for each 1,000 units...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT