A class problem for an egg production course was devised utilizing a Macintosh computer and spreadsheet software to evaluate the profit potential of a 1,000,000 bird layer enterprise. Spreadsheet templates for each student were made with differing values for each aspect of the enterprise. A 10 year period was covered and students were provided with all the necessary values for production schedules and prices. Students were then given additional "what-if" scenarios that showed comparisons with the initial assumptions and how minor changes in one aspect of the enterprise could change profit outlook. This problem provided a valuable experience in utilization of computer skills and in the use of a spreadsheet in a mangement situation.



spreadsheets, production management, egg production course, simulated computer program

Download this file (Firman_NACTA_Journal_December_1989-7.pdf)Download Article[ ]368 kB