1. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

2. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

3. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

4. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

5. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

6. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

7. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

8. Attached is a simple spreadsheet to determine pricing for an event consisting of X tables, it shows the price, the food & labor expenses, the overall profit and the profit per table. I can declare a desired profit per table and have the spreadsheet calculate the appropriate price adjustment to achieve that desired profit per table. However, I seem to be unable to create a formula where that adjustment is automatically applied to the overall price.

Can anyone help with this?

9. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

10. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

11. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

12. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

13. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

14. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

15. If you are looking for a calculation in [s]B2[/s]B4 so that B9=B8 try in [s]B2[/s]B4:
=B9*B2+B5+B6

Steve

Page 1 of 3 123 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•