b) Write Excel Formulas for given data sheetABDE1ProductProductPriceper Sales tax(10% |Net PriceNoitemof price)?name21Mouse5000keyboardjoyStick310004315004VGA cable8006.Monitor15000Total price of all items5% concession on total price7?8?9.Total bill?Dage 213

Excel formulas As the Microsoft excel window application is used to compute the…

C D E per Sales tax(10% of price) 1 Product Product Price Net Price No name item 1 Mouse 5000 ? 3 keyboard 1000 4 3 joyStick 1500 4 VGA cable 800 6. 5 Monitor 15000 Total price of all items 5% concession on total price 7 ? 8 9. Total bill ?

C D E per Sales tax(10% of price) 1 Product Product Price Net Price No name item 1 Mouse 5000 ? 3 keyboard 1000 4 3 joyStick 1500 4 VGA cable 800 6. 5 Monitor 15000 Total price of all items 5% concession on total price 7 ? 8 9. Total bill ?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Anselmo's Engineering buys circuit boards with a list price of $32,000. If the supplier extends…

A: The computation of total discount as follows: Hence, the option d) $20,893.70 is correct.

Q: Distance, in miles 0-200 201-400 401-600 601-800 801-1000 Price per 100 Ibs $100 $120 $200 $240 $400…

A: Distance = 420 miles From the table given, Price per 100 lbs for 401-600 miles = $200

Q: 2. An appliance store sold GS coffeemakers for $22.95 during a promotional sale. The store bought…

A: Operating profit is the profit which is obtained deducting expense from sales.

Q: A TV costs 567.5 OMR including 13.5% tax. Find the price if the tax is reduced to 5%. Select one: O…

A: Let TV Cost = 100 OMR Tax = 13.5% of 100 = 13.5 OMR Cost include tax = (100 + 13.5) OMR = 113.5 OMR…

Q: How much is the realized gross profit recognized in the year of sale?

A: Gross Profit is defined as the portion of sales value which is over the cost value of the product or…

Q: You place an order for 400 units of inventory at a unit price of P125. The supplier offers terms of…

A: Credit terms are 1/10, net 30 which means if the payment has been remitted within 10 days, then 1%…

Q: Discount Electronics buys stereos for $830 less 37.5% and 12.5%. Expenses are 20% of cost and the…

A: Sales are the revenues generated by the business from its day to day operations. The sales revenue…

Q: Distance, in miles 0-200 201-400 401-600 601-800 801-1000 Price per 100 Ibs $100 $120 $200 $240 $400…

A: Discounts are price reductions on a product or service in order to increase or accomplish sales. In…

Q: Problem 2: JIN Corporation started a promotional program. A towel is offered as a premium to…

A: Cash remittance P25 Cost of the towel P90 Distribution cost P10

Q: use the following information related to the selling of watches for answering 1 through 3 Selling…

A: Contribution margin on per unit basis = Selling price per watch - purchasing cost of per watch -…

Q: Sales 6000 Variable Costs 3600 Fixed Costs 2000 Earnings Before Interest and Tawes Interest Expense…

A: Degree of operating leverage is the measure which shows the change in the operating income of the…

Q: a) Find the value added tax paid by the wholesaler and the retailer. b) Find the price including…

Q: ssume that both companies have an average annual holding cost rate of 20% (1.e. it costs both…

A: The answer is stated below:

Q: How do I calculate the contribution margin for this problem (E21-21)?

A: “Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: Q8 b(i) . Selling Price :Rs. 12 Per Unit Variable Cost : 2/3 of SP Fixed Cost :Rs. 40,000 You are…

A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…

Q: Question Jazz Electronics paid S000 for a televion Operating expenses are set at 25% of cost and the…

A: Operating expense means the expense which is incurred for the operation of the business where as non…

Q: Neal's Photographic Supplied sells a Pentax camera for 440.98. The markup is 86% of cost. How much…

A: Selling Price = 440.98 Markup = 86% of Cost How much store pay for this camera = Cost Price = ?…

Q: Oman Manufacturing Company a handicraft manufacturer printed the price of its goods as RO 120 per…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: A manufacturer sells his final product for R300 plus VAT (@15%) to a wholesaler. The wholesaler…

A: The final burden of VAT is on the consumer of the product. The registered taxpayer will get the…

Q: 2. A jacket which costs PhP1,350 is being sold at PhP2,025. What is the rate of mark-up based on…

A: >Markup is the amount of difference between Cost and the selling price of a product. >Cost is…

Q: The NULL Corp. is engaged in a sales promotion, giving a rebate of P4.00 for every food box…

A: Estimated total liability = no. of boxes sold x 80% x rebate per box = 50000 x 80% x P4 = P160,000

Q: Sports Extreme advertised a Freestyle XL Stand Up Paddleboard for a regular price of $710. Sports…

A: Solution:- Calculation of above requirements as follows under:-

Q: son bonit erers uotes includes the 12 % VAT and 2 Food's selling price. At what A. P700 B. P800 C.…

A: here we have to calculate sales which is not inclusive of service tax and taxes which will be the…

Q: MOUNTAIN BIKE REI advertises mountain bikes for $199.90. If the store's cost is $2100 per dozen,…

A: Cost of 1 Bicycle: = Store's Cost/dozenNo. of bicycles in a dozen=$2,10012 = $175 Markup of a single…

Q: Somar Fashions purchases T-shirts for $22 less 28%. During a promotion, Somar Fashions sold the…

A: Mark-down: A price markdown is a decrease in the selling price of retail products that are done on…

Q: CT Computer ordered 20 units of laptop computers and received an invoice dated 25 January 2009 for…

A: The term trade discount refers to the discount by which the retailer reduces the retail price of a…

Q: M/S H.P Traders sells goods on hire purchase basis at cost plus 50%.Goods sent on H.P( H.P price)…

A: Cost: It can be defined as the total amount that is spent by a business in manufacturing a product.…

Q: A manufacturer produced a good with a value of 300, the retailer added 140 to the value of the good.…

A: The final price to the consumer is shown hereunder : Manufacturer produced a good with a value of…

Q: Home entertainment system offers am 80-inch LCD HDTV at a list price of $2459 less trade discounts…

A: trade discount = 20/10 list price = $2459

Q: VAT exclusive price VAT inclusive price _(b). VAT Amount _(a). (d) R220 (c) (e) R862.50 R126 (f)…

A: VAT amount=VAt exclusive price*VAt rate

Q: tems. Item Quantity List Price Per Unit (RM) Tire 12 370 Battery 15 210 Sport Rim ? 140 The…

A: Trade Discount and Cash Discount: Trade discount is the discount which given on the list price or…

Q: Problem 2: JIN Corporation started a promotional program. A towel is offered as a premium to…

A: Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: A 42-inch Samsung television set costs Best Buy $400 less trade discounts of 40% and 20%. Best Bu…

A: Trade Discount is the discount provided by the sellers to encourage buyers to make purchase of…

Q: LG produce refrigerators for consumer use. Each refrigerator cost LG RO250 and they sell each with…

A: Selling price per unit: It is the price at which a unit of product is sold in the market. Variable…

Q: The preside nt of Natio nal Co., after being informed that the 2021 selling price was 6% lower than…

A: Net Sales and sales price have a positive relations. When sale price increases then net sales also…

Q: Excellent Company manufactures a product that is packaged and sold. A plate is offered to customers…

A: The following transactions are journalized to show the calculations in the records of Excellent…

Q: 1. a) A set of speakers regularly sells for $59.89. The speakers are c sale today for 15% off of the…

A: Note: You have not mentioned the name of the Province, hence I am assuming "Ontario" and the…

Q: JIN Corporation started a promotional program. A towel is offered as a premium to customers who se…

A: Business transaction analysis. The following are the four stages of business transaction analysis:…

Q: Problem 2: JIN Corporation started a promotional program. A towel is offered as a premium to…

A: Cash outflow - P25 Cost of the towel P 90 Distribution expenses - P 10

Q: On June 1, Entity A sold Product XX2 for P50,000 with a cost price of P30,000. Credit terms is 2/10,…

A: Gross profit seems to be the profit a company generates after deducting all costs associated with…

Q: A $1,000 sale is made on May 1 with terms 2/10, n/30.Items with a $100 selling price are returned on…

A: The terms 2/10, n/30 means two percent discount will be given if payment is received within 10 days…

Q: A wholesaler sells a guitar for $1,427.40. What is the percent markup based on cost if the…

A: Markup = Sales price - Cost price = $1427.40 - $780 = $647.40

Q: General Merchandising Co. Selling price is P2,750, Selling expenses is P500 and the Cost to sell s…

A: As per IAS 2 Inventories, Inventory is to be measured at lower of cost or Net Realizable value Net…

Q: 10-A retailer paid VAT input RO 2,000 to the wholesaler and collected VAT output from the customer…

A: The VAT stands for value added tax to be paid to government.

Q: 3.) A wholesaler sells a guitar for $1,396.20. What is the percent markup based on cost if the…

A: Markup is the difference between a product's selling price and a cost as a percentage of the cost.…

Q: A retailer buys an alarm set for RM 850. Operating expenses are 5 % based on cost. The retailer…

A: Cost per alarm = RM850 Operating expenses on cost = 5% Profit ratio on selling price = 30%

Q: Distance, in miles 0-200 201-400 401-600 601-800 801-1000 Price per 100 lbs $100 $120 $200 $240 $400…

A: The expenses incurred during the period are recorded in the income statement for the current period.…

Q: Lsold GS coffeemakers for $22.95 during a promotional sale The store bought the cofeemakers for $36…

A: When the selling price exceeds cost, then we will get the operating profit otherwise there will be…

Question

b) Write Excel Formulas for given data sheet
A
B
D
E
1
Product
Product
Price
per Sales tax(10% |Net Price
No
item
of price)
?
name
2
1
Mouse
5000
keyboard
joyStick
3
1000
4
3
1500
4
VGA cable
800
6.
Monitor
15000
Total price of all items
5% concession on total price
7
?
8
?
9.
Total bill
?
Dage 213

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

If the price of an item displayed as $44 (GST inclusive) then what is the GST component? Select one:$44 divided by 1/11None of these10% of $4411% of $44$44 multiply by 1/11Clear my choice
HC4Q2. Based on following schedule Sales Rate Up to OMR 8000 5% OMR 8001- OMR 15000 8% OMR 15001 and Above 10% What is Hina's gross pay? Hina has net sale of OMR 11500. OMR 680 OMR 280 OMR 920 OMR 560
How do i create an NPV graph on excel using these data: Unit Sale NPV 1,000,000.00 - 2,952,452.00 1,500,000.00 - 2,001,492.00 2,000,000.00 - 1,050,533.00 2,500,000.00 - 384,861.00 2,789,077.17 - 3,000,000.00 280,811.00 3,500,000.00 946,482.00 4,000,000.00 1,612,154.00 4,500,000.00 2,277,826.00
Directions. Table Completion: Show your solution. 10 points LIST PRICE TRADE DISCOUNT DISCOUNT RATE NET PRICE P11,120.04 P1,850.50 P3,090.13 8.5% P501.25 P27,498.75
1. Complete the following table: Selling Price Cost Markup a. P 480.00 P 120.00 P 200.00 P 120.00 P 230.00 P 400.00 P 150.00 b. P 900.00 P 300.00 P 600.00 P 400.00 P 500.00 P 350.00 P 900.00 C. d. e. f. g. P 500.00 h. P 1,200.00
ACTIVITY 1: Solve each of the following problems: Complete the following table. Original Price Trade Discount Discount Rate Discounted Price ₱ 6,500 ₱ 1,200 ₱ 500 10% ₱ 2100 ₱ 5,600 ₱ 27,800 35 %
Question AR and Chave partenhp caplcot bcs 00 S00 and Stas 0, ly the income sharng A sR n ws. Add wi e parrh nd apeed that part pays S9500 A perh t The flnces t's and Cs Captal cc aer As wal wodd be OARSEND00C 0 OaR SS00, C 00
33. DETAILS BRECMBC9 18.1.010. Calculate the missing information for the purchase. (Round your answers to the nearest cent.) Sales Sales Tax Excise Selling Price Total Purchase Price (in $) Item Тax Excise Тax Tax Rate Rate (in $) (in $) Tire $112.99 6. %24 %24 24 Need Help? Read It
(e) Calculate the prices and the percentages. Cost = $114.00 Markup based on Selling Price 46% (Do not include the $ in your answer.) Selling Price = Markup = (Calculate percentages correct to 3 decimal places, do not include the % sign in your answers.) m. (Markup based on Cost) = (f) Calculate the prices and the percentages. Markup = $67.00 Markup based on Selling Price = 45% (Do not include the $ in your answer.) Cost = Selling Price = (Calculate percentages correct to 3 decimal places, do not include the % sign in your answers.) m. (Markup based on Cost) =
Calculate APR by table lookup: (Round your answers to the nearest cent.) PurchasePrice DownPayment Number ofmonthly payments Amountfinanced Total Payment $5950 $150 40 $5800 $6900 APR 5.7 % - %
Net pofit whew prods ppft is 640 corhiage sarriage inuoardls outward rent received and Othes expeses Qre I3600 will be.
Calculate the missing values and express your answers rounded to two decimal places. Cost Amount of MK Selling Price Rate of MK on Cost Rate of MK on Selling Price A $300.00 25.00% B $54.00 26.00%