Cox Electric makes electronic components and has estimated the following for a new design of one of its products:
Fixed Cost = $3,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 variable cost from total revenue, and answer
the following 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 = 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? |
| ____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. |
In: Statistics and Probability
Cox Electric makes electronic components and has estimated the following for a new design of one of its products:
Fixed Cost = $15,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 variable cost from total revenue, and answer the following 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 = 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? |
| 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. |
In: Finance
Cost functions, a part of the definition of profit, are useful to gauge the performance of the business. Suppose an economist estimated that the cost function of a single-product firm as: C(Q) = 2 + 2Q + 2Q2 Based on this information, determine the followings and show all steps (first, you must define each of the terms in the cost function, and then plug in the numbers to have your answers; not just the answers): Hint: The use of Graphs is recommended. a. Define fixed cost and offer an example. Next, compute the fixed cost of producing 4 units of output using the cost function above. b. Define variable cost and offer an example. Next compute the variable cost of producing 4 units of output using the cost function above. c. Define total cost and then compute the total cost of producing 4 units of output using the cost function above d. Define and compute the average fixed cost of producing 10 units of output e. Define and compute the average variable cost of producing 10 units of output f. Define and compute the average total cost of producing 10 units of output g. Define marginal cost an offer an example. Next, compute the marginal cost when Q = 2, using the cost function above
In: Economics
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
|
Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,761,600 | |
| Cost of goods sold | 1,235,745 | ||
| Gross margin | 525,855 | ||
| Selling and administrative expenses | 620,000 | ||
| Net operating loss | $ | (94,145 | ) |
Hi-Tek produced and sold 60,300 units of B300 at a price of $21 per unit and 12,700 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,000 | $ | 162,000 | $ | 562,000 |
| Direct labor | $ | 121,000 | $ | 42,300 | 163,300 | |
| Manufacturing overhead | 510,445 | |||||
| Cost of goods sold | $ | 1,235,745 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $56,000 and $104,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 201,085 | 90,900 | 62,600 | 153,500 | |
| Setups (setup hours) | 148,260 | 73 | 280 | 353 | ||
| Product-sustaining (number of products) | 100,600 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,500 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 510,445 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
2. Compute the product margins for B300 and T500 under the activity-based costing system.
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
2.
ompute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
3.
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
ABC hotel has 200 rooms and has a policy to determine its room rates based on consumers capacity to pay. For example busniess clients pay $1,200 per night and group tours $900 per night. The incremental cost of servicing a room is worked out at $110 per room. On average, most guest stay for three (3) nights. Rooms division manager is trying to establish if four (4) week advance reservation should be taken for a group booking of 40 rooms and three (3) nights of 7th , 8th and 9th June 2018. According to the reservation record, 80 rooms for the three (3) nights of 7th , 8th , and 9th , June 2018 are already booked by various business clients, and the historical trends of the past four (4) years suggest that 90% of the remaing 120 rooms would be sold to other busniess clients. Your are required to b) In the highly competitive environment, tourism and hospitality busniess can aspire to optimise revenue for the long term survival. Discuss " one pricing strategy " and its effect on tourism and hospitality businesses as a whole focus on the pricing strategy in tourism and hospitality business and highlight their strengths and weaknesses as reported in the published literature.
In: Accounting
In accordance with the current Conceptual Framework, define liability as one of the five elements of the statutory financial statements and outline its recognition criteria.
Further, explain whether or not you would recognise each of the following independent items as a liability, by reference to the abovementioned liability definition and recognition criteria:
In: Accounting
Your company, XYZ, Inc., wants to create an outdoor area adjacent to its office building for its employees to enjoy during lunch, breaks or during non-business hours.The city, Village Township, has restrictions of the use of the land (zoning) and the type of structures that may be erected on the land. The plans that your company have created is in violation of the city ordinances. Your company does not want to spend a lot of money to resolve negotiate with the city regarding the ordinance problem because the plans and cost of building the park are over budge. You are in charge of helping find a resolution for this conflict with the city. You report directly to the CEO of XYZ, Inc., and she has asked you to research whether arbitration, mediation or litigation would be in the best interest of both parties to resolve this conflict.
In: Operations Management
Problem 5-16 (Algo) Comparing Traditional and Activity-Based Product Margins [LO5-1, LO5-3, LO5-4, LO5-5]
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,709,200 | |
| Cost of goods sold | 1,257,251 | ||
| Gross margin | 451,949 | ||
| Selling and administrative expenses | 560,000 | ||
| Net operating loss | $ | (108,051 | ) |
Hi-Tek produced and sold 60,500 units of B300 at a price of $20 per unit and 12,800 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,300 | $ | 162,900 | $ | 563,200 |
| Direct labor | $ | 120,400 | $ | 42,400 | 162,800 | |
| Manufacturing overhead | 531,251 | |||||
| Cost of goods sold | $ | 1,257,251 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $59,000 and $100,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 212,531 | 90,500 | 62,400 | 152,900 | |
| Setups (setup hours) | 157,520 | 78 | 280 | 358 | ||
| Product-sustaining (number of products) | 100,400 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,800 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 531,251 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
2.Compute the product margins for B300 and T500 under the activity-based costing system. (Negative product margins should be indicated by a minus sign. Round your intermediate calculations to 2 decimal places.)
|
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place and and other answers to the nearest whole dollar amounts.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The following information describes the costs for a firm in a perfectly competitive market. Fill in the cells (4 points) then answer the questions that follow.
|
Quantity |
Variable Cost |
Fixed Cost |
Total Cost |
Average Variable Cost |
Average Total Cost |
Marginal Cost |
|
0 |
0 |
$300 |
-- |
|||
|
1 |
$110 |
|||||
|
2 |
$190 |
|||||
|
3 |
$250 |
|||||
|
4 |
$360 |
|||||
|
5 |
$510 |
|||||
|
6 |
$685 |
|
In: Economics
True Flight Golf manufacturers a popular shaft for golf clubs. Its trade secret is a unique process for weaving high-tension wire into the center of the shaft such that energy is accumulated during the swing and released at impact. A specialized machine costing $4,500,000 is utilized in the manufacturing process. The machine has a 3-year life and no salvage value. True Flight uses straight-line depreciation. During the year, 30,000 shafts were produced, and the company was operating at full capacity. $900,000 of wire was used during the year.
(a) Is machinery depreciation fixed or variable? Is wire fixed or variable?
(b) For the two noted cost items, how much was total variable cost and total fixed cost?
(c) For the two noted cost items, how much was variable cost per unit and how much was fixed cost
per unit?
(d) Repeat requirements (b) and (c), assuming production was only 18,000 units (and wire usage was
reduced proportionately).
(e) For the following year, if the company acquired an additional machine to enable production of
45,000 total units, what would happen to the expected total and per unit variable and fixed cost?
In: Accounting