Project 3 Solution (1) - Sales/Manufacturing/Inventory...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Sales/Manufacturing/Inventory Forecast 1 2 3 4 5 6 7 8 9 10 11 12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Sales Forecast New Product (units) - - 228 245 263 283 304 327 352 378 407 437 Revenue New Product ($s) - - 35,509 38,172 41,035 44,112 47,421 50,977 54,801 58,911 63,329 68,079 Cost New Product ($s) - - 16,245 17,463 18,773 20,181 21,695 23,322 25,071 26,951 28,973 31,146 Manufacturing Forecast New Product (Units) 20 90 200 240 300 300 300 390 390 390 390 500 Inventory New Product (Units) 20 110 82 77 113 130 126 188 226 238 222 284 New Product ($s) 1,425 7,838 5,843 5,479 8,081 9,275 8,955 13,421 16,137 16,974 15,789 20,268 Sales Price per unit $155.74 Cost per unit $71.25 Sales Growth Rate 7.50% per month Beginning month 4 Operating expense Growth Rate 3.20% per month Beginning month 2 Operating Expenses $6,200 per month in 1st month Company Funds $25,000 in 1st month
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1 2 3 4 5 6 7 8 9 10 11 12 Month Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Total Revenues New Product - - 35,509 38,172 41,035 44,112 47,421 50,977 54,801 58,911 63,329 68,079 502,345 Total Revenues - - 35,509 38,172 41,035 44,112 47,421 50,977
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Project 3 Solution (1) - Sales/Manufacturing/Inventory...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online