Excel

654 Words3 Pages
Hand Written Copy for Project One Paper support Assumption list Sales Budget | Unit Price | Input | Prior Month (March) Sales | Input | Unit Sales Increase | Input | | | | | Production Budget | Inventory On Hand | Input | Max Inventory (Greater Than) | Input | March 31, Total Inventory | Input | | | | | Materials Purchases Budget | Materials Needed Per Unit | Input | Sales Cut off | Input | High Sales | Input | Low Sales | Input | Price Per Pound | Input | Inventory On Hand | Input | Direct Labor Per Unit | Input | Min Hours Each Month | Input | Max Hours Each Month | Input | Hourly Wage | Input | Hours Greater Than 8,300 | Input | Over Time Wage | output | | | Other…show more content…
output | output | | | Total sales revenue | output | Output | output | | | | | | | | | Production Budget | April (input) | May(Input) | June(Input) | July)input) | | Current month sales units | input | input | input | Input | | Plus: Required ending inventory | output | output | output | output | | Total units needed | output | output | output | output | | Less: Beginning units inventory | output | output | output | output | | Total period units production | output | output | output | output | | | | | | | | Materials | April | May | June | July | | Unit production | output | output | output | output | | Material per unit | input | input | input | input | | Materials needed for production | output | output | output | output | | Plus: Desired ending materials inventory | output | output | output | | | Total amount material needed | output | output | output | | | Less: Materials beginning inventory | output | output | output | | | Materials to purchase | output | output | output | | | Price per pound | input | input | input | | | Total materials cost | output | output | output | | | | | | | | | Labor | April | May | June | | | Units to produce | output | output | output | | | Hours Per unit | input | input | input | | | Hours required for production | output | output | output | | | Plus: Minimum hours adjustment |
Open Document