Question: Use the SAS data table called CHOCOLATE _ ENTERPRISE _ REPORT for the following exercise. Calculate profit using total _ line _ item _ cost
Use the SAS data table called CHOCOLATEENTERPRISEREPORT for the following exercise.
Calculate profit using totallineitemcost and totallineitemsaleamt profit totallineitemsaleamt totallineitemcost
You will need to do three graphs for this exercise:
Question A Draw a daily time series with both profit and item quantity. Filter date to NOT include observations for March only for this graph Use your name as custom title of the graph and take a screen shot of the graph to be submitted later. pts
Question B On a separate graph, use monthly sums for profit and item quantity and forecast months forward do not filter out March for this one Hint: You need to create a month date variable from the daily date variable. Use your name as custom title of the graph and take a screen shot of the graph to be submitted later. pts
Based on your forecast answer the following question: What is the amount of profit forecasted for March write in your answer to the answer box below with two digits after the decimal point Create a screen shot showing your answer. pts
Question C Draw a dual axis monthly time series with profit on one of the vertical axis and item quantity on the other one. Use your name as custom title of the graph and take a screen shot of the graph to be submitted later.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
