Part A and B: You may need to use the AND/OR functions in some of your formulas. Part A: Curtiss Hardware sells battery powered drills for $99.00 each. If the customer purchases 2, 3, or 4 drills, then the price is reduced to $95.00 each. If the customer purchases 5 or more drills, then the price is reduced to $89.99 each. Sales tax is 10%. Create a worksheet that allows the customer (user) to input the number of drills that they are purchasing. Pretend that you are the user and input the number of drills that you wish to purchase. The worksheet must create an invoice which displays the following items: The price for a single drill based on the quantity entered by the user. о You MUST use the IF function to determine the price per drill. The total price of the drills purchased before the sales tax • • The amount of the sales tax • The total price of the order including the sales tax

Part A and B: You may need to use the AND/OR functions in some of your formulas. Part A: Curtiss Hardware sells battery powered drills for $99.00 each. If the customer purchases 2, 3, or 4 drills, then the price is reduced to $95.00 each. If the customer purchases 5 or more drills, then the price is reduced to $89.99 each. Sales tax is 10%. Create a worksheet that allows the customer (user) to input the number of drills that they are purchasing. Pretend that you are the user and input the number of drills that you wish to purchase. The worksheet must create an invoice which displays the following items: The price for a single drill based on the quantity entered by the user. о You MUST use the IF function to determine the price per drill. The total price of the drills purchased before the sales tax • • The amount of the sales tax • The total price of the order including the sales tax

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter17: Advanced Issues In Revenue Recognition

Section: Chapter Questions

Problem 15RE: GameDay sells recreational vehicles along with secure parking storage to customers. Game Day sells...

See similar textbooks

Similar questions

Please do not give solution in image format ?
2. Mike purchases a bicycle costing $176.90. State taxes are 4% and local sales taxes are 3%. The store charges $20 for assembly. What is the total purchase price (in $)? (Round your answer to the nearest cent.) $
You are the manager of a rental car company. A customer, Sandy Furrow, has asked you for an estimate of charges for a nine day rental of an SUV. She expects to drive 670 miles. If the company charges $52.50 per day plus 17 1/2 cents per mile for this category of vehicle, what would be the total rental charge (in $) for Sandy's trip?
I want to give my customers a discount that whey they buy one of my products they get the other item for 50% off. “buy 1 and get the 2nd item for 50% off”. Please provide a sample problem including the debit and credit entries. Thank you. Strictly no plagiarism please.
You buy goods for $3,000 and receive a voucher for $500 off your next purchase within 30 days. Based on historical experience, the vendor estimates that 90% of its customers use these vouchers. How much revenue should the vendor recognize immediately at the time of your original purchase?
can you please explain how to recognize the revenue if you have the information below using IFRS The A company sells copy machine at a sales price of JPY1,500,000 per unit. The salesprice includes delivery and installation. It also gives a maintenance service (6 years) in which atechnician checks to make sure that the machine is working properly with a price of JPY500,000(one-time prepayment).The A company has started a promotion campaign in which the maintenance service (6years) will be offered for free to a client that buys a copy machine of JPY 1,728,000.The A company has made a contract to sell a copy machine with the maintenance service(6 years) to B company by JPY 1,728,000.
Maximum Inc. (retailer) has a loyalty program that rewards its customers one point per $1 spent. Points are redeemable for $0.20 off future purchases. A customer purchases products (cost of $280) for cash at the usual selling price of $400 and earns 400 points redeemable for $80 off future purchases of goods or services. The retailer expects redemption of 360 points or 90% of points earned. a.) How should the transaction price be allocated among the performance obligation(s)?Note: Round each allocated transaction price in the table below to the nearest dollar. b. Prepare Maximum’s journal entry to record the $400 sale to the customer where the customer earned 400 loyalty points.
a computer shop charges P15.00 in every hour of computer rental.Represent your computer rental fee(R) using a function R(t)where is the number of hours you spent on the computer?
A store has a sale with 10 % off every item. When you enter the store, you receive a coupon that states you receive an additional 10 % off any sale price. If you plan to purchase an item that sells for $23, what will your total discount be (a) in dollar amount and (b) in percent?
A car air conditioner system is recharged. The cost is normally $69.95 but iscurrently $48.50.You may want the bill to show the regular price and the saleprice so that the customer knows that it was a special.You also may want tonote that this was a special in case a problem arises and you need to refundthe full price—you will want to refund the sale price, and not the regular price.Include on the bill 5.5% sales tax. Write a bill for the recharging.
Answer please.it's an accounting question.it would be really helpful. surely will upvote
Subject - account Please help me. Thankyou.