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 CHOCOLATE_ENTERPRISE_REPORT for the following exercise.
Calculate profit using total_line_item_cost and total_line_item_sale_amt (profit= total_line_item_sale_amt - total_line_item_cost).
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 31,2018 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. (2 pts)
Question B) On a separate graph, use monthly(!!!) sums for profit and item quantity and forecast 5 months forward (do not filter out March 31,2018 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. (3 pts)
Based on your forecast answer the following question: What is the amount of profit forecasted for March 2021?(write in your answer to the answer box below with two digits after the decimal point). Create a screen shot showing your answer. (2 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.
Use the SAS data table called CHOCOLATE _

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!