Budgeting assignment

WEDDING PLANNING Part II: Budgeting Your brother Randy was very grateful for your help in identifying the expenses that he and his fianc, Melissa should include in the budget for their wedding. Your parents and Melissa's are thrilled about the wedding and each have offered to pay $15,000 towards the wedding expenses so Randy and Melissa feel confident that they can plan a wedding for $30,000. However, they are still a bit confused about the concept of fixed and variable expenses. Randy and Melissa have moved into a nicer apartment in Boston with an increased monthly rent and they both still have school loans. Therefore, it is important that they stay within the $30,000 budget, so again Randy has asked for your help. Randy and Melissa have been checking on prices, and have given you this list of expenses (see below). They are planning on approximately 200 guests and would like to have the reception at a location in Boston, but need some idea of the total cost before they put down a deposit anywhere. Your task is to analyze their list of expenses, and prepare a budget for Randy and Melissa (you can use Microsoft Excel if you wish). Include the following: Categorize each expense as either fixed or variable. If it's a mixed expense, then identify both the fixed and variable components. Remember you have a guest list of 200 people and a budget of $30,000. LIST OF EXPENSES: The fees for the ceremony are $300. Gratuity for the celebrant is $300. Droo *** Your task is to analyze their list of expenses, and prepare a budget for Randy and Melissa (you can use Microsoft Excel if you wish). Include the following: Categorize each expense as either fixed or variable. if it's a mixed expense, then identify both the fixed and variable components. Remember you have a guest list of 200 people and a budget of $30,000. LIST OF EXPENSES: The fees for the ceremony are $300. Gratuity for the celebrant is $300. Decorations for the ceremony $350. Music for ceremony $300. Most of the reception venues had fees of $2,400 with costs for food of about $60 per person. Cocktail hour costs include $300 for the bartenders and $12 per person for beverages. Cost for the cake is $500 and a cutting fee of $1 per person. (Mixed) Decorations and centerpieces for the reception would be $1,200. The harp player for the cocktail hour is $150 and the DJ for the reception is $950. Invitations and reply cards involve a set up cost for the printing of $100 and a cost of $2.10 per person with postage of 1.20 per person. (Mixed) Bridal gown is budgeted at $2,000. Groom's tux rental is $250. Bride's bouquet is $240. The cost for the bouquets for the bridesmaids and the bouquet to toss are $300. Boutonnieres and Corsages will cost $200. The photographer will be $2,000. The videographer is 1,500. Limos are 700. Guest shuttle to reception is 300. Gifts for the attendants will be $400