Forum Discussion
Solved
Cost estimator for small scale catering
Hello, I need a formula to calculate how much it would cost all up to make a menu item eg, chicken sandwich by looking up each code and multiplying the quantity with its associated unit cost. I have ...
Dear Lousa Dira,
I need to make some ammendments in the previous array formula.
In the mean time, you may use the attached Excel file which contains 2 independent methods of doing the activity. Choose the one you find most appropriate.
Do let me know if any clarification is required.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
Dear Lousa Dira,
I need to make some ammendments in the previous array formula.
In the mean time, you may use the attached Excel file which contains 2 independent methods of doing the activity. Choose the one you find most appropriate.
Do let me know if any clarification is required.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
- Hi Vijaykumar,
Great! Yes this is very helpful; the added column for cost helps although I wanted to keep it separate in another sheet. I will work through and see which works best for me. Thanks!
Regards,
Louisa
