Apple sales for $2.95 a pound and you make a profit of 20% on the sale price. Grapes sells for $3.99/Lb, 25% profit, Banana $1.05, 25% Profit, Strawberry S 3.5/Lb, 25% profit. You have to pay a daily rent of $75 for the space you rent in a corner of a supermarket, no other expenses required. Create a template that will calculate your daily net profit/Loss for any quantities of sales of the fruit. use yellow as fill color for all the cells where you enter quantities for each fruit. Format the table properly for design and numbers.

A person sells widgets. It costs 154 to buy the materials today. In a year, the sales of widgets will result in revenues of 899 and costs of 116. if the discount rate is 0.05, what is the npv?

how to do it in excel?

You have a business selling and delivering pizzas to businesses for lunch. You pay $4,000 per month in rent, $320 for utilities, and $2,000 a month for salaries. You also have delivery cars that cost $1,000 per month. Your variable costs are $8 per pizza for ingredients and $4 per pizza for delivery costs. You sell the pizzas for $20 each. Round up if necessary What is the number of pizzas you need to sell to break even for the month If you want to make a profit of 2,000 per month, how many pizzas do you need to sell? Round up if necessary Go back to the original numbers If the price of cheese goes up and your variable costs go by $3 what is your new break even in pizzas if you increase your price to $21 Round up if necessary Golden Company has a fleet of delivery trucks and has the following Overhead costs per month with the miles driven Miles Driven Total Costs March 50.000 194.000 Aprill 40.000 170.200 this is the low May 60.000 217.600 June 70.000 241.000 Use the High-Low method to…