years ago as a one-person, cabinet-making operation. Employees were added as the business expanded. Last year, sales volume totaled $850,000. Volume for the first five months of the current year totaled $600,000, and sales were expected to be $1.6 million for the entire year. Unfortunately, the cabinet business in the region where

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Please help me thouroughly answer part 3 and 4 of this question. Refer to the template pictures below for answers and ignore numbers already entered. Please include calculaions and how you got to the answer. Thank you!

Case 7-65. Cost-Volume-Profit with Multiple Products, Sales Mix Changes, Changes in Fixed and Variable Costs
Objective 1, 4

Artistic Woodcrafting Inc. began several years ago as a one-person, cabinet-making operation. Employees were added as the business expanded. Last year, sales volume totaled $850,000. Volume for the first five months of the current year totaled $600,000, and sales were expected to be $1.6 million for the entire year. Unfortunately, the cabinet business in the region where Artistic is located is highly competitive. More than 200 cabinet shops are all competing for the same business.

Artistic currently offers two different quality grades of cabinets: Grade I and Grade II, with Grade I being the higher quality. The average unit selling prices, unit variable costs, and direct fixed costs are as follows:

  Unit Price Unit Variable Cost Direct Fixed Cost
Grade I $3,400   $2,686   $95,000  
Grade II 1,600 1,328 95,000
Common fixed costs (fixed costs not traceable to either cabinet) are $35,000. Currently, for every three Grade I cabinets sold, seven Grade II cabinets are sold.

Required:

1. Calculate the number of Grade I and Grade II cabinets that are expected to be sold during the current year.

2. Calculate the number of Grade I and Grade II cabinets that must be sold for Artistic to break even.


3. Artistic can buy computer-controlled machines that will make doors, drawers, and frames. If the machines are purchased, the variable costs for each type of cabinet will decrease by 9%, but common fixed cost will increase by $44,000. Compute the effect on operating income, and also calculate the new break-even point. Assume the machines are purchased at the beginning of the sixth month. Fixed costs for the company are incurred uniformly throughout the year.


4. Refer to the original data. Artistic is considering adding a retail outlet. This will increase common fixed cost by $70,000 per year. As a result of adding the retail outlet, the additional publicity and emphasis on quality will allow the firm to change the sales mix to 1:1. The retail outlet is also expected to increase sales by 30%. Assume that the outlet is opened at the beginning of the sixth month. Calculate the effect on the company's expected profits for the current year, and calculate the new break-even point. Assume that fixed costs are incurred uniformly throughout the year.

 

Add a retail store and use the initial data without the new machine
All data and analysis are for the last 7 months of the year
Common fixed costs increase by $70,000
Sales mix changes to 50% grade 1 and 50% grade 2
Sales increase by 30% to $1,300,000
O Let X =packet of grade 1 and grade 2 packages
2 sales last 7 months=Sales mix grade 1*X*(price grade 1)+Sales mix grade 2*X*(price grade 2)
4
Unit Sales for Package
Unit Sales Grade 1
Unit Sales Grade 2
260
262
374
7 Change in CM=CM grade 1*(new units grade 1-old units grade 1)+CM grade 2*(new units grade 2-old units grade 2)
Change in CM
66198
2 Change in fixed costs over the last 7 months
40833
4
5 change in operating income=change in CM-change in fixed costs
Change in operating income
25365
Transcribed Image Text:Add a retail store and use the initial data without the new machine All data and analysis are for the last 7 months of the year Common fixed costs increase by $70,000 Sales mix changes to 50% grade 1 and 50% grade 2 Sales increase by 30% to $1,300,000 O Let X =packet of grade 1 and grade 2 packages 2 sales last 7 months=Sales mix grade 1*X*(price grade 1)+Sales mix grade 2*X*(price grade 2) 4 Unit Sales for Package Unit Sales Grade 1 Unit Sales Grade 2 260 262 374 7 Change in CM=CM grade 1*(new units grade 1-old units grade 1)+CM grade 2*(new units grade 2-old units grade 2) Change in CM 66198 2 Change in fixed costs over the last 7 months 40833 4 5 change in operating income=change in CM-change in fixed costs Change in operating income 25365
Sales for the last seven months of the year are $1,000,000
- The new contribution margins:
CM grade 1 CM grade 2
$
956 $
392
= The new weighted-average CM is
Weighted Average CM
5,612
the new fixed costs
Fixed Costs
$ 269,000
Let X= package of cabinets
sales=S1*X*(price grade 1)+S2*X*(price grade 2)
# of packets last 7 month Grade 1 Units Grade 2 Units
47
141
329
Change in CM=new grade 1 units*(new CM grade 1-old CM grade 1)+new grade 2 units*(new CM grade 2-old CM grade 2)
Change in CM
73,602
New Breakeven Quantity for Package=(new fixed costs)/(new weighted average CM)
New Breakeven Quantity of a Package New Breakeven Grade 1
New Breakeven Grade 2
48
144
336
Transcribed Image Text:Sales for the last seven months of the year are $1,000,000 - The new contribution margins: CM grade 1 CM grade 2 $ 956 $ 392 = The new weighted-average CM is Weighted Average CM 5,612 the new fixed costs Fixed Costs $ 269,000 Let X= package of cabinets sales=S1*X*(price grade 1)+S2*X*(price grade 2) # of packets last 7 month Grade 1 Units Grade 2 Units 47 141 329 Change in CM=new grade 1 units*(new CM grade 1-old CM grade 1)+new grade 2 units*(new CM grade 2-old CM grade 2) Change in CM 73,602 New Breakeven Quantity for Package=(new fixed costs)/(new weighted average CM) New Breakeven Quantity of a Package New Breakeven Grade 1 New Breakeven Grade 2 48 144 336
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education