make sure to do all parts I'll rate
Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage
Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows:
| Estimated Fixed Cost |
Estimated Variable Cost (per unit sold) |
||||||
| Production costs: | |||||||
| Direct materials | $26 | ||||||
| Direct labor | 17 | ||||||
| Factory overhead | $431,300 | 13 | |||||
| Selling expenses: | |||||||
| Sales salaries and commissions | 89,600 | 6 | |||||
| Advertising | 30,300 | ||||||
| Travel | 6,700 | ||||||
| Miscellaneous selling expense | 7,400 | 5 | |||||
| Administrative expenses: | |||||||
| Office and officers' salaries | 87,600 | ||||||
| Supplies | 10,800 | 2 | |||||
| Miscellaneous administrative expense | 10,220 | 3 | |||||
| Total | $673,920 | $72 | |||||
It is expected that 7,020 units will be sold at a price of $288 a unit. Maximum sales within the relevant range are 9,000 units.
Required:
1. Prepare an estimated income statement for 20Y7.
| Belmain Co. | |||
| Estimated Income Statement | |||
| For the Year Ended December 31, 20Y7 | |||
| $ | |||
| Cost of goods sold: | |||
| $ | |||
| Cost of goods sold | |||
| Gross profit | $ | ||
| Expenses: | |||
| Selling expenses: | |||
| $ | |||
| Total selling expenses | $ | ||
| Administrative expenses: | |||
| $ | |||
| Total administrative expenses | |||
| Total expenses | |||
| Income from operations | $ | ||
2. What is the expected contribution margin
ratio? Round to the nearest whole percent.
%
3. Determine the break-even sales in units and dollars.
| Units | units |
| Dollars | units |
4. Construct a cost-volume-profit chart on your
own paper. What is the break-even sales?
$
5. What is the expected margin of safety in dollars and as a percentage of sales?
| Dollars: | $ | |
| Percentage: (Round to the nearest whole percent.) | % |
6. Determine the operating leverage. Round to one decimal place.
In: Accounting
8 - 14. Vaasa Chemicals has a Mixing Department and a Refining Department. The following information refers to the Mixing Department:
Units:
Work in Process July 1 20,000
Units Started 60,000
Completed and transferred
To the Refining Department 30,000
Costs: Beginning costs Added in July
Chemicals P & Q $ 220,750 $650,000
Conversion costs 125,000 232,500
Chemicals P and Q are both required materials for producing the product. The supervisor’s beginning estimates for completion of materials and work in process are 20% for materials and 30% for conversion cost. The ending work in process in the Mixing Department is 75% with respect to materials, and 50% complete with respect to conversion costs.
Prepare a Process costing report for the Mixing Department for July using the Weighted Average Equivalent Units method.
Include:
1. Account for the actual physical units
2. Compute the Equivalent units for the period March 2010 for Materials and Conversion
Costs
3. Compute the total costs of Direct Materials and Conversion Costs for the Drawing
Department.
4. Compute the dollar amount per Equivalent unit. Round to the nearest cent.
5. Assign overall costs to the Drawing Department. Round to the nearest dollar.
Round to the nearest cent or dollar as instructed above.
Weighted-Average Method
|
1. Units to account for: |
||
|
Beginning Work in Process |
|
|
|
Units started into production |
______ |
|
|
Total units to account for |
|
|
2 |
Equivalent Units of Production |
|||
|
Materials |
Conversion |
|||
|
Transferred to next department............. |
||||
|
Ending work in process: |
||||
|
Materials: units x % complete... |
______ |
|||
|
Conversion: units x % complete... |
______ |
|||
|
Equivalent units of production............... |
||||
|
3 |
Cost per Equivalent Unit |
||
|
Materials |
Conversion |
||
|
Cost of beginning work in process.............. |
|||
|
Cost added during the period.................... |
_______ |
________ |
|
|
Total cost (a)........................................... |
|||
|
Equivalent units of production (b).............. |
|||
|
4 |
Cost per equivalent unit, (a) ÷ (b).............. |
5. Costs assigned to the Cooking Department:
Materials Conversion Cost Total costs
Transferred out: =
Work in Process _______ ________ = _________
Total costs
In: Accounting
Estimated Income Statements, using Absorption and Variable Costing
Prior to the first month of operations ending October 31 Marshall Inc. estimated the following operating results:
| Sales (24,800 x $86) | $2,132,800 | ||
| Manufacturing costs (24,800 units): | |||
| Direct materials | 1,282,160 | ||
| Direct labor | 302,560 | ||
| Variable factory overhead | 141,360 | ||
| Fixed factory overhead | 168,640 | ||
| Fixed selling and administrative expenses | 45,900 | ||
| Variable selling and administrative expenses | 55,500 | ||
The company is evaluating a proposal to manufacture 27,200 units instead of 24,800 units, thus creating an Inventory, October 31 of 2,400 units. Manufacturing the additional units will not change sales, unit variable factory overhead costs, total fixed factory overhead cost, or total selling and administrative expenses.
a. 1. Prepare an estimated income statement, comparing operating results if 24,800 and 27,200 units are manufactured in the absorption costing format. If an amount box does not require an entry leave it blank or enter “0”.
| Marshall Inc. | ||
| Absorption Costing Income Statement | ||
| For the Month Ending October 31 | ||
| 24,800 Units Manufactured | 27,200 Units Manufactured | |
| Sales | $ | $ |
| Cost of goods sold: | ||
| Cost of goods manufactured | $ | $ |
| Inventory, October 31 | ||
| Total cost of goods sold | $ | $ |
| Gross profit | $ | $ |
| Selling and administrative expenses | ||
| Income from operations | $ | $ |
a. 2. Prepare an estimated income statement, comparing operating results if 24,800 and 27,200 units are manufactured in the variable costing format. If an amount box does not require an entry leave it blank or enter “0”.
| Marshall Inc. | ||
| Variable Costing Income Statement | ||
| For the Month Ending October 31 | ||
| 24,800 Units Manufactured | 27,200 Units Manufactured | |
| Sales | $ | $ |
| Variable cost of goods sold: | ||
| Variable cost of goods manufactured | $ | $ |
| Inventory, October 31 | ||
| Total variable cost of goods sold | $ | $ |
| Manufacturing margin | $ | $ |
| Variable selling and administrative expenses | ||
| Contribution margin | $ | $ |
| Fixed costs: | ||
| Fixed factory overhead | $ | $ |
| Fixed selling and administrative expenses | ||
| Total fixed costs | $ | $ |
| Income from operations | $ | $ |
In: Accounting
Required information
[The following information applies to the questions
displayed below.]
Delph Company uses a job-order costing system and has two manufacturing departments—Molding and Fabrication. The company provided the following estimates at the beginning of the year:
| Molding | Fabrication | Total | |||||
| Machine-hours | 24,000 | 33,000 | 57,000 | ||||
| Fixed manufacturing overhead costs | $ | 800,000 | $ | 240,000 | $ | 1,040,000 | |
| Variable manufacturing overhead cost per machine-hour | $ | 5.00 | $ | 1.00 | |||
During the year, the company had no beginning or ending inventories and it started, completed, and sold only two jobs—Job D-70 and Job C-200. It provided the following information related to those two jobs:
| Job D-70: | Molding | Fabrication | Total | |||
| Direct materials cost | $ | 370,000 | $ | 320,000 | $ | 690,000 |
| Direct labor cost | $ | 200,000 | $ | 140,000 | $ | 340,000 |
| Machine-hours | 14,000 | 10,000 | 24,000 | |||
| Job C-200: | Molding | Fabrication | Total | |||
| Direct materials cost | $ | 240,000 | $ | 240,000 | $ | 480,000 |
| Direct labor cost | $ | 140,000 | $ | 280,000 | $ | 420,000 |
| Machine-hours | 10,000 | 23,000 | 33,000 | |||
Delph had no underapplied or overapplied manufacturing overhead during the year.
2. Assume Delph uses departmental predetermined overhead rates based on machine-hours.
a. Compute the departmental predetermined overhead rates.
b. Compute the total manufacturing cost assigned to Job D-70 and Job C-200.
c. If Delph establishes bid prices that are 150% of total manufacturing costs, what bid prices would it have established for Job D-70 and Job C-200?
d. What is Delph’s cost of goods sold for the year?
Complete the question by entering your answers in the tabs given below.
Compute the departmental predetermined overhead rates. (Round the final answers to 2 decimal places.)
|
||||||||||
In: Accounting
Python Programming- 9.10 MT Practice Simple Food Receipt 2B
"""
Enhance your simple food receipt
a. Ask the user for inputs about two food items using the following
prompts in turn [add a space after each
question mark]. Do not forget to assign each user
entry to a unique variable name (do not display the Note to add a
space just use print() to add a space between each
set of input statements):
Item 1? [add a space after the question mark]
Item 1 price? [add a space after the question mark]
Item 1 number? [add a space after the question mark]
[Note: add space here using print()]
Item 2? [add a space after the question mark]
Item 2 price? [add a space after the question mark]
Item 2 number? [add a space after the question mark]
[Note: add space here using print()]
Item 3? [add a space after the question mark]
Item 3 price? [add a space after the question mark]
Item 3 number? [add a space after the question mark]
[Note: add space here using print()]
b. Convert the price and quantity variables to integers
c. Calculate the total cost for the order by calculating each
item's total price by
multiplying price and quantity for each item and then adding up the
total prices for the three items
d. Calculate the total cost plus tax for the order by multiplying
the total cose calculated in c by the tax
rate of .0545 (5.45 percent tax) then adding the tax to the total
cost
e. Display the results using the structure below. Edit the format
string "${:,.2f}".format(identfier) to format the
results of your calculation as currency with the PHP currency type,
a space between PHP and the calculated costs,
and 1 decimal place:
RECEIPT
You ordered: [Item 1] [Item 2] [Item 3]
Your cost: [total price for all items calculated in 3c above,
formatted with PHP currency and 1 decimal place]
Your cost w tax: {total cost plus tax calculated in 3d above,
formatted with PHP currency and 1 decimal place}
"""
#Start your code below
In: Computer Science
The StamfordStamford store of Gabriel's CornerGabriel's Corner , a chain of small neighborhood convenience stores, has a Kaizen (continuous improvement) approach to budgeting monthly activity costs for each month of 20152015.
Gabriel's CornerGabriel's Corner
has three product categories: soft drinks (35% of cost of goods sold [COGS]), fresh snacks (25% of COGS), and packaged food (40% of COGS). The following table shows the four activities that consume indirect resources at the
StamfordStamford
store, the cost drivers and their rates, and the cost-driver amount budgeted to be consumed by each activity in January
20152015.
1 (Click
the icon to view the four activities and their cost data.)
Each successive month, the budgeted cost-driver rate decreases by
0.10.1 %
relative to the preceding month. So, for example, February's budgeted cost-driver rate is
0.9990.999
times January's budgeted cost-driver rate, and March's budgeted cost-driver rate is
0.9990.999
times the budgeted February rate.
Gabriel's CornerGabriel's Corner
assumes that the budgeted amount of cost-driver usage remains the same each month.
Read the
requirements2.
Requirement 1. What are the total budgeted costs for each activity and the total budgeted indirect cost for March
20152015 ?
Begin by calculating the budgeted cost-driver rates for February, then calculate March. (Round your answers to five decimal places, X.XXXXX.)
|
Budgeted Cost-Driver Rates |
|||
|
Activity |
January |
February |
March |
|
Ordering |
$85.00 |
||
|
Delivery |
84.00 |
||
|
Shelf-stocking |
24.00 |
||
|
Customer support |
0.22 |
||
Now calculate total budgeted cost for each activity and the total budgeted indirect cost for March. (Use the rates you calculated above in your calculations. Round your answers to the nearest whole number.)
|
Soft |
Fresh |
Packaged |
||
|
Activity |
Drinks |
Snacks |
Food |
Total |
|
Ordering |
||||
|
Delivery |
||||
|
Shelf-stocking |
||||
|
Customer support |
||||
|
Total |
Requirement 2. What are the benefits of using a Kaizen approach to budgeting? What are the limitations of this approach, and how might
Gabriel's CornerGabriel's Corner
management overcome them?
Begin by reviewing the following statements and then select whether each one is a benefit or limitation of a Kaizen approach to budgeting.
|
A. |
It will show unfavorable variances for managers whose activities do not meet the required monthly cost reductions. This likely will put more pressure on managers to creatively seek out cost reductions. |
(1) |
|
B. |
It assumes small incremental improvements each month. It is possible that some cost improvements arise from large discontinuous changes. |
(2) |
|
C. |
Company takes into consideration employee suggestions. They believe that employees who actually do the job, whether in manufacturing, sales, or distribution, have the best information and knowledge of how the job can be done better. |
(3) |
For any limitations selected above, determine how
Gabriel's CornerGabriel's Corner
management might overcome them? (Leave unused cells blank.)
|
(4) |
|
(5) |
|
(6) |
1: Data Table
|
January 2015 |
January 2015 Budgeted |
||||
|
Budgeted |
Amount of Cost Driver Used |
||||
|
Cost-Driver |
Soft |
Fresh |
Packaged |
||
|
Activity |
Cost Driver |
Rate |
Drinks |
Snacks |
Food |
|
Ordering |
Number of purchase orders |
$85 |
13 |
26 |
13 |
|
Delivery |
Number of deliveries |
$84 |
11 |
68 |
21 |
|
Shelf-stocking |
Hours of stocking time |
$24.00 |
19 |
178 |
94 |
|
Customer support |
Number of items sold |
$0.22 |
4,400 |
34,300 |
10,600 |
2: Requirements
|
1. |
What are the total budgeted costs for each activity and the total budgeted indirect cost for March 20152015 ? |
|
2. |
What are the benefits of using a Kaizen approach to budgeting? What are the limitations of this approach, and how might Gabriel's CornerGabriel's Corner management overcome them? |
(1)
Benefit
Limitation
(2)
Benefit
Limitation
(3)
Benefit
Limitation
(4)
Companies must relieve the pressure on managers by eliminating the monthly cost reduction requirements.
Companies need to highlight the importance of seeking large discontinuous improvements as well as small incremental ones.
Suggestions for improvements must come from top management to be effective.
(5)
Companies must relieve the pressure on managers by eliminating the monthly cost reduction requirements.
Companies need to highlight the importance of seeking large discontinuous improvements as well as small incremental ones.
Suggestions for improvements must come from top management to be effective.
(6)
Companies must relieve the pressure on managers by eliminating the monthly cost reduction requirements.
Companies need to highlight the importance of seeking large discontinuous improvements as well as small incremental ones.
Suggestions for improvements must come from top management to be effective.
In: Accounting
Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow.
| Units | Total | Total | Total Machine |
|---|---|---|---|
| Produced | Lumber Cost | Utilities Cost | Depreciation Cost |
| 15,000 shelves | $180,000 | $18,250 | $135,000 |
| 30,000 shelves | 360,000 | 35,500 | 135,000 |
| 60,000 shelves | 720,000 | 70,000 | 135,000 |
| 75,000 shelves | 900,000 | 87,250 | 135,000 |
1. Determine whether the costs in the table are variable, fixed, mixed, or none of these.
|
Variable Cost |
Fixed Cost |
Mixed Cost |
None of these |
||
|---|---|---|---|---|---|
| Lumber | |||||
| Utilities | |||||
| Depreciation |
2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N= Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers.
| Cost | Fixed Portion of Cost | Variable Portion of Cost (per Unit) |
| Lumber | ||
| Utilities | ||
| Depreciation |
High-Low
Biblio Files Company is the chief competitor of Cover-to-Cover Company in the bookshelf business. Biblio Files is analyzing its manufacturing costs, and has compiled the following data for the first six months of the year. After reviewing the data, answer questions (1) through (3) that follow.
| Month | Number of Units Produced | Total Cost |
|---|---|---|
| January | 4,360 | $65,600 |
| February | 225 | 6,250 |
| March | 1,000 | 15,000 |
| April | 5,475 | 111,250 |
| May | 1,750 | 32,500 |
| June | 3,015 | 48,000 |
1. From the data previously provided, help Biblio Files Company estimate the fixed and variable portions of its total costs using the High-Low Method. Recall that Total Costs = (Variable Cost Per Unit x Number of Units Produced) + Fixed Cost. Complete the following table.
| Total Fixed Cost | Variable Cost per Unit |
2. With your Total Fixed Cost and Variable Cost per Unit from the High-Low Method, compute the total cost for the following values of N (Number of Units Produced).
| Number of Units Produced | Total Costs |
| 3,500 | |
| 4,360 | |
| 5,475 |
3. Why does the total cost computed for 4,360 units not match the data for January in the table at the top of this panel?
The High-Low method gives a formula for the estimated total cost and may not match levels of production other than the highest and lowest.
The High-Low method gives accurate data only for levels of production outside the relevant range.
The High-Low method is accurate only for months in which production is at full capacity.
The High-Low method only gives accurate data when fixed costs are zero.
Contribution Margin
Review the contribution margin income statements for Cover-to-Cover Company and Biblio Files Company on their respective Income Statements panels. Complete the following table from the data provided in the income statements. Each company sold 84,800 units during the year.
| Cover-to-Cover Company | Biblio Files Company | |
| Contribution margin ratio (percent) | ||
| Unit contribution margin | ||
| Break-even sales (units) | ||
| Break-even sales (dollars) |
Income Statement - Cover-to-Cover
|
Cover-to-Cover Company |
|
Contribution Margin Income Statement |
|
For the Year Ended December 31, 20Y7 |
|
1 |
Sales |
$424,000.00 |
||
|
2 |
Variable costs: |
|||
|
3 |
Manufacturing expense |
$212,000.00 |
||
|
4 |
Selling expense |
21,200.00 |
||
|
5 |
Administrative expense |
63,600.00 |
296,800.00 |
|
|
6 |
Contribution margin |
$127,200.00 |
||
|
7 |
Fixed Costs: |
|||
|
8 |
Manufacturing expense |
$5,000.00 |
||
|
9 |
Selling expense |
4,000.00 |
||
|
10 |
Administrative expense |
54,600.00 |
63,600.00 |
|
|
11 |
Income from operations |
$63,600.00 |
Income Statement - Biblio Files
|
Biblio Files Company |
|
Contribution Margin Income Statement |
|
For the Year Ended December 31, 20Y7 |
|
1 |
Sales |
$424,000.00 |
||
|
2 |
Variable costs: |
|||
|
3 |
Manufacturing expense |
$169,600.00 |
||
|
4 |
Selling expense |
16,960.00 |
||
|
5 |
Administrative expense |
33,920.00 |
220,480.00 |
|
|
6 |
Contribution margin |
$203,520.00 |
||
|
7 |
Fixed Costs: |
|||
|
8 |
Manufacturing expense |
$121,920.00 |
||
|
9 |
Selling expense |
8,000.00 |
||
|
10 |
Administrative expense |
10,000.00 |
139,920.00 |
|
|
11 |
Income from operations |
$63,600.00 |
Sales Mix
Biblio Files Company is making plans for its next fiscal year, and decides to sell two new types of bookshelves, Basic and Deluxe. The company has compiled the following estimates for the new product offerings.
| Type of Bookshelf | Sales Price per Unit | Variable Cost per Unit |
|---|---|---|
| Basic | $5.00 | $1.75 |
| Deluxe | 9.00 | 8.10 |
The company is interested in determining how many of each type of bookshelf would have to be sold in order to break even. If we think of the Basic and Deluxe products as components of one overall enterprise product called “Combined,” the unit contribution margin for the Combined product would be $2.31. Fixed costs for the upcoming year are estimated at $346,962. Recall that the totals of all the sales mix percents must be 100%. Determine the amounts to complete the following table.
| Type of Bookshelf | Percent of Sales Mix | Break-Even Sales in Units | Break-Even Sales in Dollars |
| Basic | |||
| Deluxe |
Target Profit
Refer again to the income statements for Cover-to-Cover Company and Biblio Files Company on their respective Income Statement panels. Note that both companies have the same sales and net income. Answer questions (1) - (3) that follow, assuming that all data for the coming year is the same as the current year, except for the amount of sales.
1. If Cover-to-Cover Company wants to increase its profit by $40,000 in the coming year, what must their amount of sales be?
2. If Biblio Files Company wants to increase its profit by $40,000 in the coming year, what must their amount of sales be?
3. What would explain the difference between your answers for (1) and (2)?
The companies have goals that are not in the relevant range.
Cover-to-Cover Company’s contribution margin ratio is lower, meaning that it’s more efficient in its operations.
Biblio Files Company has a higher contribution margin ratio, and so more of each sales dollar is available to cover fixed costs and provide income from operations.
The answers are not different; each company has the same
required sales amount for the coming year to achieve the desired
target profit.
In: Accounting
Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow.
|
Units |
Total |
Total |
Total Machine |
|---|---|---|---|
|
Produced |
Lumber Cost |
Utilities Cost |
Depreciation Cost |
|
13,000 shelves |
$156,000 |
$15,950 |
$145,000 |
|
26,000 shelves |
312,000 |
30,900 |
145,000 |
|
52,000 shelves |
624,000 |
60,800 |
145,000 |
|
65,000 shelves |
780,000 |
75,750 |
145,000 |
1. Determine whether the costs in the table are variable, fixed, mixed, or none of these.
|
Variable Cost |
Fixed Cost |
Mixed Cost |
None of these |
||
|---|---|---|---|---|---|
|
Lumber |
|||||
|
Utilities |
|||||
|
Depreciation |
2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N= Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers.
|
Cost |
Fixed Portion of Cost |
Variable Portion of Cost (per Unit) |
|
Lumber |
||
|
Utilities |
||
|
Depreciation |
High-Low
Biblio Files Company is the chief competitor of Cover-to-Cover Company in the bookshelf business. Biblio Files is analyzing its manufacturing costs, and has compiled the following data for the first six months of the year. After reviewing the data, answer questions (1) through (3) that follow.
|
Month |
Number of Units Produced |
Total Cost |
|---|---|---|
|
January |
4,360 |
$65,600 |
|
February |
275 |
6,250 |
|
March |
1,000 |
15,000 |
|
April |
4,775 |
73,750 |
|
May |
1,750 |
32,500 |
|
June |
3,015 |
48,000 |
1. From the data previously provided, help Biblio Files Company estimate the fixed and variable portions of its total costs using the High-Low Method. Recall that Total Costs = (Variable Cost Per Unit x Number of Units Produced) + Fixed Cost. Complete the following table.
|
Total Fixed Cost |
Variable Cost per Unit |
2. With your Total Fixed Cost and Variable Cost per Unit from the High-Low Method, compute the total cost for the following values of N (Number of Units Produced).
|
Number of Units Produced |
Total Costs |
|
3,500 |
|
|
4,360 |
|
|
4,775 |
3. Why does the total cost computed for 4,360 units not match the data for January in the table at the top of this panel?
The High-Low method is accurate only for months in which production is at full capacity.
The High-Low method gives accurate data only for levels of production outside the relevant range.
The High-Low method only gives accurate data when fixed costs are zero.
The High-Low method gives a formula for the estimated total cost and may not match levels of production other than the highest and lowest.
Contribution Margin
Review the contribution margin income statements for Cover-to-Cover Company and Biblio Files Company on their respective Income Statements panels. Complete the following table from the data provided in the income statements. Each company sold 84,800 units during the year.
|
Cover-to-Cover Company |
Biblio Files Company |
|
|
Contribution margin ratio (percent) |
||
|
Unit contribution margin |
||
|
Break-even sales (units) |
||
|
Break-even sales (dollars) |
Income Statement - Cover-to-Cover
|
Cover-to-Cover Company |
|
Contribution Margin Income Statement |
|
For the Year Ended December 31, 20Y7 |
|
1 |
Sales |
$424,000.00 |
||
|
2 |
Variable costs: |
|||
|
3 |
Manufacturing expense |
$212,000.00 |
||
|
4 |
Selling expense |
21,200.00 |
||
|
5 |
Administrative expense |
63,600.00 |
296,800.00 |
|
|
6 |
Contribution margin |
$127,200.00 |
||
|
7 |
Fixed Costs: |
|||
|
8 |
Manufacturing expense |
$5,000.00 |
||
|
9 |
Selling expense |
4,000.00 |
||
|
10 |
Administrative expense |
54,600.00 |
63,600.00 |
|
|
11 |
Income from operations |
$63,600.00 |
Income Statement - Biblio Files
|
Biblio Files Company |
|
Contribution Margin Income Statement |
|
For the Year Ended December 31, 20Y7 |
|
1 |
Sales |
$424,000.00 |
||
|
2 |
Variable costs: |
|||
|
3 |
Manufacturing expense |
$169,600.00 |
||
|
4 |
Selling expense |
16,960.00 |
||
|
5 |
Administrative expense |
33,920.00 |
220,480.00 |
|
|
6 |
Contribution margin |
$203,520.00 |
||
|
7 |
Fixed Costs: |
|||
|
8 |
Manufacturing expense |
$121,920.00 |
||
|
9 |
Selling expense |
8,000.00 |
||
|
10 |
Administrative expense |
10,000.00 |
139,920.00 |
|
|
11 |
Income from operations |
$63,600.00 |
Sales Mix
Biblio Files Company is making plans for its next fiscal year, and decides to sell two new types of bookshelves, Basic and Deluxe. The company has compiled the following estimates for the new product offerings.
|
Type of Bookshelf |
Sales Price per Unit |
Variable Cost per Unit |
|---|---|---|
|
Basic |
$5.00 |
$1.75 |
|
Deluxe |
9.00 |
8.10 |
The company is interested in determining how many of each type of bookshelf would have to be sold in order to break even. If we think of the Basic and Deluxe products as components of one overall enterprise product called “Combined,” the unit contribution margin for the Combined product would be $2.31. Fixed costs for the upcoming year are estimated at $346,962. Recall that the totals of all the sales mix percents must be 100%. Determine the amounts to complete the following table.
|
Type of Bookshelf |
Percent of Sales Mix |
Break-Even Sales in Units |
Break-Even Sales in Dollars |
|
Basic |
|||
|
Deluxe |
Target Profit
Refer again to the income statements for Cover-to-Cover Company and Biblio Files Company on their respective Income Statement panels. Note that both companies have the same sales and net income. Answer questions (1) - (3) that follow, assuming that all data for the coming year is the same as the current year, except for the amount of sales.
1. If Cover-to-Cover Company wants to increase its profit by $40,000 in the coming year, what must their amount of sales be?
2. If Biblio Files Company wants to increase its profit by $40,000 in the coming year, what must their amount of sales be?
3. What would explain the difference between your answers for (1) and (2)?
The answers are not different; each company has the same required sales amount for the coming year to achieve the desired target profit.
Cover-to-Cover Company’s contribution margin ratio is lower, meaning that it’s more efficient in its operations.
Biblio Files Company has a higher contribution margin ratio, and so more of each sales dollar is available to cover fixed costs and provide income from operations.
The companies have goals that are not in the relevant range.
In: Accounting
Decompose the Income Statement into labor and facility sustaining cost pools. Divide the cost pools into activity centers at the ratio of 40% for the BOH and 60% for the FOH. Display in the table.
|
Revenue |
$111,122.85 |
|
F&B cost |
$46,940.33 |
|
Salaries |
$6,000.00 |
|
Employer Taxes |
$779.63 |
|
Employee Meals |
$200.30 |
|
Telephone |
$14.18 |
|
Equipment Leases |
$46.38 |
|
Travel & Entertainment |
$17.88 |
|
Utilities |
$700.00 |
|
Activity Centers |
Labor |
Facility Sustaining |
|
FOH |
||
|
BOH |
||
|
Total |
4. Based on the calculation from #3, calculate cost pool rates
|
Answer: |
5. Calculate an allocation value per menu item for the Facility Sustaining cost pool. The number of menu items sold during the month = 2,000.
|
Answer: |
6. Last week, 9.75 bottles of 1L Jack Daniel was used. The POS system recorded sales of 102 drinks. If the standard drink size is 1.50 oz, how many potential drinks should have been sold last week?
|
Answer: |
7. Last week, 9.75 bottles of 1L Jack Daniel was used. The bar pays $25 per bottle and the POS system recorded sales of 98 drinks. If the standard drink size is 1.30 oz and is sold for $6.00 per drink, what is the actual cost % of Jack Daniel?
|
Answer: |
8. The Night Owl Bar sold 189 of Chivas Regal last month generating sales of $897.75. A bottle of Chivas Regal costs $38.95, with a bottle size of 1.5L. A standard drink size of 1.20 oz is sold for $6.25. The bar sells 32 brands and 9 categories. If the total liquor CM is $17.762.42 and total CM for Whisky category is $1.723.51, what is the profit factor for Whisky category?
|
Answer: |
In: Accounting
The Carlberg Company has two manufacturing departments, assembly and painting. The assembly department started 10,000 units during November. The following production activity unit and cost information refers to the assembly department’s November production activities.
| Assembly Department | Units |
Percent of Direct Materials Added |
Percent of Conversion |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Beginning work in process | 2,000 | 60 | % | 40 | % | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Units transferred out | 9,000 | 100 | % | 100 | % | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Ending work in process | 3,000 | 80 | % | 30 | % | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting