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.

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.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Find the selling price. A store pays $8 for a pool noodle. The markup is 20%.
nt HomewoIR. TOTA Each day a small business owner sells 200 pizza slices at $1.50 per slice and 85 sandwiches at $3.50 each. Business expenses come to $140 per day What is the owner's profit for a ten-day period? The profit is $ Clear all Check answer View an example Get more help- Next Help me solve this
Your store sells notebooks at P80.00. You make 7% profit on these items. The product has not been selling well and you are considering having a promo. If running a promo event costs you P800.00 to implement, and you'd like to offer the merchandise at P76.00, how much do you have to sell to break even?
Sharla is comparing a credit plan to buying an appliance for cash. The sticker price is $1200. The down payment for the credit plan is 10% and then 24 monthly payments of $53.25. What is the cost of buying on credit?
You are buying and reselling items found at your local thrift shop. You found an antique pitcher for sale. If you need a 46% markup on cost and know most people will not pay more than $25 for it, what is the most you can pay for the pitcher? Note: Round your answer to the nearest cent. Maximum pay I
A clothing retailer is going to mail out 10,000 catalogues. It costs $2 to mail out each catalogue. When a customer places an order from a catalogue assume a profit of $50 per order is earned. It is assumed that 5% of those who receive a catalogue will place an order however, this number can vary. Use the file below to help you with your tables. Assume that: [total profit = total profit made from the orders – the amount spent on mailing out the catalogues]. a) Use a one-variable data table to determine how the total profit earned from the mailing will vary depending on a response rate between 4% and 10% (with increments of 2%). b) Create a two-variable data table to show how the total profit changes with a varying response rate and number of catalogues mailed. Vary the response rate between 4% and 10% with increments of 2% and vary the number of catalogues mailed from 10,000 to 30,000 at increments of 5000.
Joel, a florist, buys and sells flowers at his store. He purchases roses at $3.00 each, has operating expenses of 22% on cost, and has profits of 100% on cost. Calculate the following. a. Desired profit per rose: Round to the nearest cent b. Amount of markup: Round to the nearest cent G Selling price: Roundte the neareat.cent d. Rate of markup on selling price: Reundte n amal plar
You are creating a business from home and your neighbor is willing to sell to you a brand-new BBQ Grill for $150. You want to sell it in Amazon, who charges a $5.00 insertion fee and a comission of 3.0% based on the selling price. Your delivery expenses amounted to $25. 1. What is your minimum list price for the BBQ Grill to ensure that you at least cover your expenses?
The regular price for a dishwasher is 399. Best Buy is having a sale for 20% off all dishwashers. You also have a coupon which can be used for $20 off any purchase over $200 or $50 off any purchase over $400. Sales tax is 7.4%. Determine the total amount paid for the dishwasher, including any discounts and taxes paid.
You are buying and reselling items found at your local thrift shop. You found an antique pitcher for sale. If you need a 40% markup on cost and know most people will not pay more than $20 for it, what is the most you can pay for the pitcher? Round to the nearest cent.
Additional Activities After learning how to compute the gross profit at least you have learned now how to do it by your own. Solve and compute the following: 1. A watch store owner decided to offer 20% discount for a particular brand of watch that sells at P35,000.00. By doing so, his average sales increased from 5 watches to 12 watches a day. If he bought one watch at a price of P22,000.00 from the suppiier, by how much was his daily profit increased or decreased by offering such discount on the watch? 2 Michelle went to Baguio and bought 20 jars of strawberry jam for P3,500.00 with 1 5% discount. When she got back to Manila, she sold 10 of the jars for a total of P1,800.00and the rest as P185.00 each. How much profit did Michelle again?
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…