Wildcat 1 (1)

Wildcat 1 (1) - Schedule I 1. Production: 228 Units/month...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Wildcat Company, Inc. Project 1 To: SIE 265 Class From: VP of Marketing Subject: Financial Model of Proposed Production Increase Project Wildcat Company, Inc (WCI) is proposing to upgrade its manufacturing facility in order to meet an unexpected increase in customer demand for product. I am requesting that class construct a set of pro-forma financial statements with analysis for an upper management meeting. Your job will be to recommend whether to proceed or abandon the Project by the end of the semester. Schedule I (below) outlines the initial assumptions provided by other operating groups within the company. These assumptions will change as further information becomes available. The excel model constructed for this assignment should be designed with flexibility so that key input parameters can be easily modified.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Schedule I 1. Production: 228 Units/month beginning in month 3. No units are manufactured in months 1 & 2. Assume that all units manufactured are sold. 2. Revenue per unit: $151.94 3. Cost per Unit: $67.27 4. Operating Expenses: $5,883/month beginning in the 1 st month. 5. Company Funding: $15,000 in the 1 st month. 6. Any Income Statement or Cash Flow Statement field not specified above should be left blank. 1 st Project Assignment : Construct a preliminary Income Statement and Statement of Cash Flows by month in Excel for the fiscal year of February 2012 through January 2013. Use the .ppt Template provided as a guide. Output values should be formatted to display dollars only (no cents) except for items like cost per unit....
View Full Document

This note was uploaded on 02/16/2012 for the course ENGR 265 taught by Professor Arnold during the Spring '09 term at Arizona.

Ask a homework question - tutors are online