Q1. Murray furniture store sells couches as a retailer. The wholesale cost to them of their most popular model of couch varies depending on how many they purchase for sale. For the first 200 couches the cost is $299 each; for the next 200 couches it drops to $250 each; and for every couch after that it costs $225. Create an excel function using the IF function to show the gross profit under the following scenarios: a. b. It sells at a price of $650 and 350 units are purchased for sale and sold It sells at a price of $625 and 300 units are purchased for sale and sold It sells at a price are $700 and 1,000 units are purchased for sale and sold C.

Q1. Murray furniture store sells couches as a retailer. The wholesale cost to them of their most popular model of couch varies depending on how many they purchase for sale. For the first 200 couches the cost is $299 each; for the next 200 couches it drops to $250 each; and for every couch after that it costs $225. Create an excel function using the IF function to show the gross profit under the following scenarios: a. b. It sells at a price of $650 and 350 units are purchased for sale and sold It sells at a price of $625 and 300 units are purchased for sale and sold It sells at a price are $700 and 1,000 units are purchased for sale and sold C.

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

Use Exhibit 18-1 to determine the sales tax (in $) and calculate the total purchase price (in $) for the item. (Round your answers to the nearest cent.) Item SellingPrice SalesTax TotalPurchase Price Hair dryer $19.22
Homoward Hardware buys cat liter for $6 less 20% per bag. The store's overhead is 45% of cost and the owner requires a profit of 20% of cost (a) (b) (c) (d) (e) (7) For how much should the bags be sold? What is the amount of markup included in the selling price? What is the rate of markup based on selling price? What is the rate of markup based on cost? What is the break-even price? What operating profit or loss is made if a bag is sold for $7 509
Assume that markup is based on selling price. Calculate the dollar markup and cost. Note: Round your answers to the nearest cent. Item Canon scanner Selling price $ 72 Markup percent 30 % Dollar markup Cost
Home Depot wants to buy a new line of fertilizers. Manufacturer A offers a 21/11 chain discount. Manufacturer B offers a 26/10 chain discount. Both manufacturers have the same list price. a. What is the percentage of discount for both manufacturers? (Do not round intermediate calculations. Round your final answers to the nearest hundredth percent.) Percentage of Discount Manufacturer A Manufacturer B es b. What manufacturer should Home Depot buy from? Manufacturer B Manufacturer A Prev 6 of 15 Next > M
Assume in each case that the selling expenses are $9 per unit and that the normal profit is $6 per unit. Calculate the limits for each case. Then enter the amount that should be used for lower of cost or market. Selling Price Upper Limit Replacement Cost Lower Limit Cost LCM (a) $63 $ $44 $ $53 $ (b) 52 35 39 (c) 59 44 45 (d) 54 38 36
As shown below, a shop purchases and sells a certain type of product. Purchasing price : $10 per unit Selling price : $15 per unit Fixed cost : $1,000 How many units are sold at a “break even” point, where there is neither a profit nor a loss?
A factory sells an item to the wholesalers at a profit of 5%. The wholesaler sells the item to the retailer at a profit of 10%. The retailer sells the item to the public at a profit of 25%. All businesses add VAT of 15%. Required: 2.1 Complete the following table. Factory Wholesaler Retailer Cost Price R 600 ? 5 430,00 ? 3 345,60 ? ? 100,00 ? ? Profit ? ? 2.2 Complete the table below by calculating the missing amounts. Amount (R) VAT (R) 156,80 ? ? VAT ? ? ? 15,68 0 Exempt Selling Price ? ? ? TOTAL (R) ? ? 4058,40 ? ? 74,90 ?
A wholesaler purchases widgets for $8 per unit from the manufacturer and sells it to retailers who then sell to consumers. The wholesaler marks up by 20% on the retailer purchase price, while the retailers mark up by 25% on the wholesaler selling price. Here, the retail selling price to the consumer is: O $12.00 O $12.80 All the other 4 answers are correct. $12.50 O $13.33
Choose the correct letter of answer Bautista Company produces and sells a particular home appliance. The variable cost (VC) per unit is P50. The unit selling price (SP) is P120 while fixed cost (FC) is P70,000. What is the revenue function in this case? a. C = 50x + 70,000b. P = 120x – 50x – 70,000c. R = 120x d. none of the above
1. A computer table sells for $198.50 and costs $158.70. Find the markup. Find the rate of markup based on the cost. a) b) 2. A flower arrangement is marked up $15, which is 30% of the cost. i) Find the cost. ii) Find the selling price.
Home Depot sells a couch for $250.50. The dollar amount of markup on the couch is $95.72. Round all dollar values to two decimal places and percentages to two decimals (i. e 34.56%). a. What is the cost to Home Depot? [1 pt] b. What is the markup on selling percentage? 1pt
Same question as above but need help with the following questions please a-2. From an operating profit (loss) perspective for March, should Miles Audio accept the order from Lanoo Custom Systems? b. What is the minimum price Miles Audio should accept to take the special order from Lanoo Custom Systems?