Budget and Financial Panning

Find out

- Gordon Helps is planning a function. There are two possible venues.• TCG club which have fixed rental cost of $2000 plus a charge of $50 per person for its own catering of meals andserving of drinks and hors d'oeuvres.• TT Hall, which have a fixed rental cost of $4000.The cost to hire a caterer for meals and drinks will cost $45 perperson.* Gordon Helps budget $4000 for admin and marketing. The band will cost a fixed amount of $3200. The tickets costfor this event is $200 per person. Requirement:• Compute the break even for each venue in term of tickets sold• Compute the operating income on the bill if 138- At what level of tickets sold will the two (2) venues have the same operating income?

Instructions Sally owns the East End Pizza Shop. She has been so busy and successful; she wants to open a second store called the West End Pizza Shop. She has lined up investors and a bank loan but before she signs on the dotted line, she is going to crunch some numbers. Here is the information that she has compiled: . . . . . The cost of the new store's building is $200,000 The cost of new pizza ovens is $12,000 She will have to spend $50,000 to renovate the new building Sally wants to own the new shop for 5 years at which time she will close up and retire in Florida. In 5 years she expects to sell her business for $215,000 She expects to be able to sell 4,000 pizzas in the first year and 5% more pizzas each subsequent year The price of a pizza is $15.00 and costs $4.50 to make On average she sells 3.2 cans of pop with every pizza The price of a can of pop is $2.00 and costs $0.75 from the supplier Her electricity bill will be $500 per year She will have to pay $20,000 per year for…

Total cost

Attached is question diagram, USE EXCEL AS ITS REQUIRED Question 9. What is the net present worth of machine B after tax over 3 years? Pick the correct answer. $6,394 $6,233 $5,562 $7,070

Godo

Your bike helmet company is expecting demand for an additional 4,000 helmets in the upcoming year. While you have the capacity to handle the additional demand, a potential supplier has offered to make the 4,000 helmets for $9 per helmet. Other information from the financial accounting system is listed below. Should you make or buy the helmets? Commuter bike helmet Direct material Direct labor Manufacturing overhead: variable Non-manufacturing overhead: variable Total variable cost Manufacturing overhead: fixed Non-manufacturing overhead: fixed Total fixed cost Total cost Commuter helmet price Machine hour $6.54 $1.89 $1.07 $0.86 $10.36 $1.78 $0.98 $2.76 $13.12 $16.00 0.57

Can you please help me to solve this problem using EXCEL spreadsheet and please show all Excel formulas used for each section. Thank you

5

A hotel management want to expand the convention center.  The types of possible conference rooms given in the following table:    Size (square meter)  Cost  Option 1  400  $18.000  Option 2  750  $33.000  Option 3  1050  $45.150  Management prefers that the total expansion is under 25.000 square meter and their budget is $1.000.000. In this case, what is the maximum cost of the construction of the convention center which does not exceed the budget and has the largest area?

Computer Based Information Systems Project - Breakeven Analysis Beautiful Pots, Inc., a producer of pottery, is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs comprised of $2,000 in rent for a building and $7,200 in salaries per month. The variable costs are comprised of 30 cents for labor, 30 cents for material, and 10 cents for utilities per unit produced. Each item is sold to retailers at a price of $1.50. 1. What volume per month is required in order to break-even? 2. What profit would be realized on a monthly volume of 61,000 units? 87,000 units? 3. What volume is needed to obtain a profit of $16,000 per month? 4. What volume is needed to provide revenue of $23,000 per month? 5. Include a data table to show alternative break-even points, assuming variations in salaries and labor costs. Assume values of labor cost per unit from $ 0.20 to $ 0.60 (increments of $ 0.05) and salaries…

Please answer I really need help

3

Assume that Jeff Heun has reviewed his work schedule and decided that it makes sense to complete this project on time. Assuming that he now believes that the probability for completing the project on time is 95% and otherwise it will be finished 1 week late, determine the transaction price. Transaction price   $enter the transaction price in dollars

Please give me answer very fast in 5 min saur