Using Data Analytics to Analyze CVP Relationships Manufacturing companies often use past data to predict future costs and profits. The reliability of past

Using Data Analytics to Analyze CVP Relationships

Manufacturing companies often use past data to predict future costs and profits. The reliability of past data comes into play, however, given the company’s mix of variable and fixed costs as well as the consistency of its selling price. If cost behavior is consistent, forecasts may be more reliable.

Dashco produces and sells children’s rocking chairs, distributing them to major retailers. There are minor fluctuations in the unit variable production costs due to efficiencies and pay rates of the labor force, and varying materials prices. The production department is considering the use of alternative demand-based data in its forecasts.

Data containing the units sold and unit variable costs for the first three months of the year, along with amounts for total fixed overhead costs and selling, general, and administrative (SG&A) costs for the first three months of the year are shown in the following file:

  • Module 2 CTA Excel File TemplateDownload Module 2 CTA Excel File Template

Requirements

There are three requirements to this problem. Use the included Excel file to perform each of the following.

  1. Populate the total costs and the operating income columns of a new data table in the Student Work area for each day provided in the three-month period.
  2. Perform a forecast using Excel’s Forecast Sheet tool based on the new data table. Excel will place the data on a new separate worksheet for you on the provided Excel file.
  3. You talked to the manufacturing group and they told you that they use Google search data to create a demand forecast, which is very accurate. A scatter graph of the expected operating income using the search index is provided here.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that a

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that addresses the following questions. Using the ESG Reporting, explain how the company addresses each aspect – Environmental, Social and Governance In your personal opinion, does information reported

Instructions This  assignment will help students understand interface implementation as a  crucial software engineering component. You will implement the

Instructions This  assignment will help students understand interface implementation as a  crucial software engineering component. You will implement the given  interface in JAVA. Overall interface coding This assignment requires you  to write the Utilities211Code.java class which implements the  Utilities211Interface.java interface shown below. After you have written  the code for the

About an Accounting Internship  Introduction (1 paragraph).  Briefly inform the reader of the Experiential Learning Activity you took part in by

About an Accounting Internship  Introduction (1 paragraph).  Briefly inform the reader of the Experiential Learning Activity you took part in by describing:   The name, date(s), and location(s) of the experiential learning event you participated in A brief overview of the organization’s mission and how it fits with your goals. A description