Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required information Excel Analytics 2 - 7 4 : Basic Cost Behaviors: Visualization Skip to question [ The following information applies to the questions displayed
Required information
Excel Analytics : Basic Cost Behaviors: Visualization
Skip to question
The following information applies to the questions displayed below.
Salvay Company is a small manufacturer that produces and sells one product for use in medical instruments. Demand is erratic and can vary widely from year to year. The financial managers at Salvay are planning for the coming year and have asked for your help in forecasting unit costs and gross margin.
Stacey Choo, the cost accountant at Salvay, provides you with information about the components of manufacturing costs along with specifying the behavior of the components. This information is summarized in the memo on the next page.
Stacey also tells you that the company has a zeroinventory policy and all projections are made under that assumption. Finally, she points out that capacity constraints require assuming a second shift for the year if annual production volume exceeds units.
The marketing manager tells you that the best estimate of the price of the product is $ per unit. His best guess is that demand could be as low as units or as high as units.
Salvay Company Memo:
To: Jorge Alcala, Controller
From: Stacey Choo, Cost Accountant
Date: November
Subject: Cost Information Projections
As you requested, the following table summarizes our best estimates for manufacturing costs for the upcoming fiscal year. These estimates are valid for any reasonable range of production.
Cost Category Cost Behavior Cost Information
Direct costs:
Materials Semivariable If production volume is below units, we can source all our materials from Bourke Supplies at $ per unit. This is a negotiated price. For any production greater than this, we will have to pay the going market price of $ per unit.
Labor Variable $ per unit.
Overhead:
Indirect plant labor Variable $ per unit.
Indirect plant supplies Variable $ per unit.
Machine depreciation Fixed $ per year.
Plant depreciation Fixed $ per year.
Plant maintenance Step $ per shift.
Plant supervision Step $ per shift.
Plant utilities Step $ for production up to units;
$total if production is over units.
Property taxes on plant Fixed $ per year.
Stacey Choo would like you to prepare a presentation for the CFO and Controller at Salvay discussing the estimated gross margins. They are especially interested in the effect of the individual cost items on the gross margins. Stacey also mentions that both managers like to see visual support for any conclusions.
Excel Analytics PR : Submit Your Excel File
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started