please use excel

The local DnD is trying to determine how many pumpkin munchkins to bake each day. The distribution of the number of pumpkin munchkin customers is: Customers order 1,2,3 or 4 dozen pumpkin munchkins according to the following distribution: Munchkins sell for $3.50 per dozen. They cost $2.00 per dozen to make. All munchkins not sold at the end of the day are sold at half price to a local NotsoFresh Market. Automation constraints require munchkins to be made in batches of 10 dozen. Using Monte Carlo simulation in Excel, simulate customers and their order then use that to determine the net profit that DnD will make for each of the possible batches it can bake each day. What is your recommendation (based on profit) for how many batches (of 10 dozen) munchkins DnD should make each day