You are to develop an excel spreadsheet model that will do both the average cost and FIFO process cost computations with only having to input the data once.

You will be graded primarily on:

Efficiency of spreadsheet structure. The goal would be to develop a model where you could simply input any data and automatically generate accurate results without amending any formula cells or hunting all over for a place to put a number. Your spreadsheet will be tested with another data set to determine if it generates the desired results.