Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Several data analysis tools are including in linear programming, time series forecasting and cost profit value analysis. We will use the time series forecasting to

Several data analysis tools are including in linear programming, time series forecasting and cost profit value analysis. We will use the time series forecasting to help calculate the price of seeds, the price of oil, and the price for by-product mash. The three-year-moving average method will be used to find the forecasting costs. First, we need to solve for the amount of seed required from each supplier, to meet our requirement, for the lowest price. By utilizing the excel problem solver, we find the answer. Then we determine the 3-period moving average. After that, we find the cost of the seed by multiplying the forecasted price by the percentage bought from each supplier. We then find the total revenue by multiplying the forecasted price of the oil and the mash by the respective percentages produced. Then to find the net revenue, we subtract the cost of the seed, the fixed cost and the variable cost, and subtract it from the gross revenue

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Kin Lo, George Fisher

3rd Edition Vol. 1

133865940, 133865943, 978-7300071374

Students also viewed these Accounting questions