V or H Look Up ( Accounting Job)
everblazing
bubbles_hot_tubs.xlsxSheet1
| DUO | SQUARE | ROUND | |
| TOTAL SALES REVENUE | 3400 | 1700 | 2550 |
| TOTAL MATERIAL COST | 351.9 | 306 | 382.5 |
| TOTAL LABOUR COST | 680 | 340 | 510 |
| TOTAL EXPENSE COST | 510 | 212.5 | 340 |
Sheet2
| SELLING PRICE(£) | BUDGETED CAPACITY (£) | ACTUAL PRODUCTION CAPACITY (£) | MATERIAL COST PER UNIT (£) | TOTAL SALES REVENUE (£) | TOTAL MATERIAL COST (£) | LABOUR COST PER UNIT (£) | TOTAL LABOUR COST (£) | EXPENSE COST PER UNIT (£) | TOTAL EXPENSE C0ST (£) | PRODUCTION OVERHEADS (£) | OTHER OVERHEADS (£) | TOTAL PROFIT (£) | TOTAL COST PER UNIT (£) | PROFIT PER UNIT (£) | PROFIT MARK UP (£) | PROFIT MARGIN (£) | |
| DUO | 1000 | 2000 | 3400 | 103.5 | 3400000 | 351900 | 200 | 680000 | 150 | 510000 | 115000 | 20500 | 1722600 | 1656906.02941176 | 506.6470588235 | 625084.029268293 | 1722.6 |
| SQUARE | 2000 | 1000 | 1700 | 360 | 3400000 | 612000 | 400 | 680000 | 250 | 425000 | 172500 | 34000 | 1476500 | 1889520 | 868.5294117647 | 597543.426470588 | 738.25 |
| ROUND | 1500 | 1500 | 2550 | 225 | 3825000 | 573750 | 300 | 765000 | 200 | 510000 | 143000 | 29000 | 1804250 | 1991761.37254902 | 707.5490196078 | 653062.215517241 | 1202.8333333333 |
| ^ |
