Cox Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost $12,750 • Material cost per unit = $0.16 • Labor cost per unit $0.12 • Revenue per unit $0.62 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? to units (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. units

Cox Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost $12,750 • Material cost per unit = $0.16 • Labor cost per unit $0.12 • Revenue per unit $0.62 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (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 = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? to units (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. units

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

A local firm manufactures children’s toys. The projected demand over the next four months for one particular model of toy robot is (given) Assume that a normal workday is eight hours. Hiring costs are $350 per worker and firing costs (including severance pay) are $850 per worker. Holding costs are $4.00 per aggregate unit held per month. Assume that it requires an average of 1 hour and 40 minutes for one worker to assemble one toy. Shortages are not permitted. Assume that the ending inventory for June was 600 of these toys and the manager wishes to have at least 800 units on hand at the end of October. Assume that the current workforce level is 35 workers. Find the optimal plan by formulating as a linear program.
Cranston Company estimates the following overhead costs for the coming year: Equipment depreciation $160,000Equipment maintenance 60,000Supervisory salaries 40,000Factory rent 100,000Total $360,000 Cranston is also budgeting $600,000 in direct labor costs and 15,000 machine hours for the coming year.(a) Calculate the predetermined overhead rate using direct labor costs as the allocation base. (b) Calculate the predetermined overhead rate using machine hours as the allocation base.
Tyrene Products manufactures recreational equipment. One of the company’s products, a skate-board, sells for $37.50. The skateboards are manufactured in an antiquated plant that relies heavily on direct labor workers. Thus, variable costs are high, totaling $22.50 per skateboard of which60% is direct labor cost.Over the past year the company sold 40,000 skateboards, with the following operating results: Sales (40,000 skateboards) $1,500,000 Variable expenses 900,000 Contribution margin 600,000 Fixed expenses 480,000 Net operating income $ 120,000 Management is anxious to maintain and perhaps even improve its present level of income from theskateboards. Required: 1. Compute ( a ) the CM ratio and the break-even point in skateboards, and ( b ) the degree of oper-ating leverage at last year’s level of sales. 2. Due to an increase in labor rates, the company estimates that variable costs will increase by$3 per skateboard next year. If this change takes place and the selling…
College Creations, Inc (CC), builds a loft that is easily adaptable to most dorm rooms or apartments and can be assembled into a variety of configurations. Each loft is sold for $500, and the cost to produce one loft is $300, including all parts and labor. CC has fixed costs of $100,000. A.What happens if CC produces nothing? B.Now, assume CC produces and sells one unit (loft). What are their financial results? C.Now, what do you think would happen if they produced and sold 501 units? D.How many units would CC need to sell in order to break even? E.How many units would CC need to sell if they wanted to have a pretax profit of $50,000?
Felton Paper produces paper for textbooks. Felton plans to produce 500,000 cases of paper next quarter to sell at a price of $100 per case. The variable cost per case, including both manufacturing andselling costs, is $80. What is the total contribution margin for next quarter?
You have been asked to estimate the cost of 100 prefabricated structures to be sold to a local school district. Each structure provides 1,000 square feet offloor space, with 8-feet ceilings. In 1999, you produced 70 similar structures consistingof the same materials and having the same ceiling height, but each provided only 800square feet of floor space. The material cost for each structure was $25,000 in 1999, andthe cost capacity factor is 0.65. The cost index values for 1999 and 2006 are 200 and 289,respectively. The estimated manufacturing cost for the first 1,000-square-foot structureis $12,000. Assume a learning curve of 88% and use the cost of the 50th structure asyour standard time for estimating manufacturing cost. Estimate the total material costand the total manufacturing cost for the 100 prefabricated structures.
A washing machine manufacturer works on 8 hours shift in a year (assume 2021 calendar) excluding Saturday and Sunday. Demand estimates for the number of washing machine that could be sold next year are shown below: Demand (units) 2000 4000 5000 Processing Time (std time hrs) 3.0 5.0 6.0 (a) Assuming the firm produces on an expected value basis, what is the annual production capacity of one machine in standard hours? (b) What capacity is required to meet 170% percent of expected demand?
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $150,000. Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $49. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,400 copies? For subtractive or negative numbers use a minus sign. $ (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue = total cost yielding a profit of zero. In which interval of demand does breakeven occur? (i) Breakeven appears in the interval of 3,000 to 3,200 copies. (ii)…
The owner of a large machine shop has just finished its financial analysis from the prior fiscal year. The following is an excerpt from the final report Net revenue $ 343,000 Cost of goods sold 302,000 Value of production materials on hand 42,500 Value of work-in-progress inventory 69,000 Value of finished goods on hand 28,000 Compute the inventory turnover ratio (ITR). (Round 1 decimal place) Compute the weeks of supply (WS) (Do not round immediate calculation. Round 1 decimal place)
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $170,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $45. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,700 copies? For subtractive or negative numbers use a minus sign. $ (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitivity of profit to demand. Breakeven occurs where profit goes from a negative to a positive value, that is, breakeven is where total revenue = total cost yielding a profit of zero. In which interval of demand does breakeven occur? (i) Breakeven appears in the interval of 3,800 to 4,000 copies. (ii) Breakeven appears in the interval of…
An urgent care clinic is staffed by two physicians who can each see four patients per hour. The clinic is open 6 p.m. until midnight, seven days per week. The clinic tracked the average number of patients arriving by hour for a month and observed the following:Time Demand6–7 87–8 108–9 109–10 410–11 411–12 2a. Sketch a graph with one line showing capacity and another line showing demand.b. What observations do you make from the graph in part a?c. What suggestions would you make to the clinic for managing its capacity?
Use the following information for the next 3 problems: ABC Company plans to construct a 60,000 sq. ft private warehouse and rent public warehouse as needed. Warehouse inventory turns at the rate of 2 times per month. One pound of merchandise occupies 0.2 cubic feet of warehouse space and can be stacked 10 feet high. Given aisles, and normal operating efficiency, only 50 percent of the total warehouse space is actually used for storage. Assume the facility is being built to size so no additional space is allowed for future product growth. A private warehouse can be constructed for $36 per sq. ft. and can be amortized over 20 years. Annual fixed costs amount to $20 per sq. ft. of total space. The cost of operation is $0.03 per pound of throughput. Space may also be rented for a storage charge on inventory of $0.06 per pound per month and a handling charge of $0.05 per pound of throughput. Monthly demands for a typical year are as follows: Month Demand (lb) Jan 2,000,000…