You're having a dinner party. You're inviting couples, their children, and dogs. You're not sure who you'll invite yet.
Write a program to work out how many place setting items you will need, depending on the number of adults, children, and dogs you invite.
Each adult gets a salad plate, a salad fork, a dinner plate, a dinner knife, a dinner fork, a dessert bowl, a dessert spoon, a water glass, a wine glass, and a napkin.
Each child gets a dinner plate, a dinner knife, a dinner fork, a dessert bowl, a dessert spoon, a water glass, and two napkins.
Each dog gets four napkins, a food bowl, a water bowl, and two dog treats.
An extra four napkins are added, as spares.
Compute totals, as in the following example:
Write everything in VBA. Do not use formulas in the worksheet.
Upload your Excel file.
(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)