Annual Report

How did your team use DATATABLES and CONDITIONAL FORMATTING? Describe each datatable that you created including the variables that you were changing, the range of values that you used for the variables, and the calculated value (objective) of the conditional formatting. Also, how did you use conditional formatting to shade the values in the datatable to help your managers find the desired settings for your company strategy? [The datatable(s) must be visible in your excel file].

We used data tables to look at our maximum quarterly profit by changing the machine setup time and the machine production rate. For the machine setup time we used a range from 2.5-12 hours and for the production rate, our range was 21000 to 100000.

We used the color scales formatting to show the highest profit in green and minimum profit in red.

PRODUCT DESIGN STRATEGY: For each raw material listed below, show a graph of the historical price of the material along with any curve fitting that you chose to assist your forecasting (From Excel, copy  paste special  Image).

Wheat Graph: what value are you predicting to use in your model? Why?

Predicted Price: $0.8470

Reason: Based on our forecast of 5 days in the future, we are expecting wheat prices to go down. So we selected the average price of the forecasted prices.

Oats Graph: what value are you predicting to use in your model? Why?

Predicted Price: $0.8393

Reason: Based on 5 periods forecast, it seems like the prices for Oats are always going down. The average of the forecasted prices ($0.8393) looks like a good prediction for oat’s prices.

Nuts Graph: what value are you predicting to use in your model? Why?

Predicted Price: $2.25

Reason: Based on the forecasts for nuts, it looks like prices of nuts will go up, $2.25 seems a reasonable price to choose because, and we think nuts’ prices will be going up.

Blueberries Graph: what value are you predicting to use in your model? Why?

Predicted Price: $...