Using the below information open an excel file and create aSales Budget, a Cash Receipt Schedule and a Production Budget forFiwrt for the months of Oct, Nov, and Dec. Make sure to use properformat including dollar signs and headers - this will count in thegrade. Upload the excel file as your response.
Fiwrt Corporation manufactures and sells stainless steel coffeemugs. Expected mug sales (in units) are expected to be as follows:September – 32,000, October – 30,000, November – 36,000, December –34,000, and January 35,000.
Selling Price is expected to be $8 per mug. 40% of sales are onaccount. All sales on account are collected in the following month.Fiwrt likes to maintain a finished goods inventory equal to 30% ofthe next month's estimated sales. |
