Answered: the formula (not function) to calculate… | bartleby

Survey of Accounting (Accounting I)

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter6: Receivables And Inventories

Section: Chapter Questions

Problem 6.4MBA

See similar textbooks

Related questions

Question

the formula (not function) to calculate for the missing data. The answer must be in the same format as Google Sheets formulas.

ABC STORE
Number of
2.
Product
List Price
Discount
Sales Price
Sales Tax
Total Price
Units
36.
37.
38.
39.
40.
41.
46
47.
48.
49
50
Beauty Products
420
800
100
3
Handbags
150
789
43
42
4.
Perfumes
200
890
88
43.
6.
Accessories
98
460
25
44.
7.
Summer Clothes
75
560
30
45
8.
Write the formula for the following. Use cell referencing.
9
10
36-40. Sales Price is List Price - Discount
11
41-45. Sales Tax is Sales Price multiply by 0.05
12
46-50. Total Price is the sum of Sales Price and Sales Tax.
13

Expert Solution

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to determine the firms cost of goods sold for 2012. Remember to change the year in row 24 and to enter new beginning inventory balances. Save the 2012 file as MFG3. Print the worksheet when done. If sales and other expenses were identical in 2011 and 2012, during which year did Twisp earn more income? Why?
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
using the details on the photo attached, compute for the cost of goods sold using average cost retail.
Explain the step by step instructions given the following data for the items 1, 2, 3, 4 and 5 below. Units Price Beginning Inventory 200 $1.20 First Purchase 400 $1.30 Second Purchase 250 $1.40 Sales 550 $2.00 Assuming a FIFO cost flow, the amount of cost of goods sold reported on the income statement would be what? Assuming a LIFO cost flow, the amount of ending inventory reported on the balance sheet would be what? Assuming a weighted average cost flow, the amount of ending inventory reported on the balance sheet would be (round the final answer to the nearest dollar) would be what? In a period of rising prices, which inventory cost flow method results in the lowest balance sheet figure for inventory? In a period of rising prices, which inventory cost flow method results in the lowest income tax liability, all other things being equal?
Applying the Cost of Goods Sold Model Charest Company has the following data for 2022: Item Units Cost Inventory, 12/31/2021 980 $10,780 Purchases 4,480 49,280 Inventory, 12/31/2022 750 8,250 Required: 1. How many units were sold? 2. Using the cost of goods sold model, determine the cost of goods sold.
Explain the step by step instructions given the following data for the questions below. Units Price Beginning Inventory 200 $1.20 First Purchase 400 $1.30 Second Purchase 250 $1.40 Sales 550 $2.00 Assuming a FIFO cost flow, the amount of cost of goods sold reported on the income statement would be what? Assuming a LIFO cost flow, the amount of ending inventory reported on the balance sheet would be what? Assuming a weighted average cost flow, the amount of ending inventory reported on the balance sheet would be (round the final answer to the nearest dollar) would be what? In a period of rising prices, which inventory cost flow method results in the lowest balance sheet figure for inventory? In a period of rising prices, which inventory cost flow method results in the lowest income tax liability, all other things being equal?
I honestly need help on FIFO, LIFO, weighted average, and specific method on these chapter 7 questions. The following transactions occurred for the month of May. Date Units Cost Total Sales Price 1-May Beginning Balance 65 13 $845 2-May Purchase 75 14 $1,050 3-May Purchase 70 16 $1,120 10-May Sale 100 $30 15-May Purchase 40 17 $680 17-May Sale 45 $30 30-May Sale 100 $30 Calculate the Cost of Goods Sold, Ending inventory, and Gross Profit for the month under Weighted Averages. Do not round the unit cost. Do round total costs to the nearest cent on each transaction. End of the month totals Cost of Goods Sold $ Ending Inventory $ Gross Profit $
Guess Clothing Store sells jeans. During January 2022, its inventory records for one brand of designer jeans were as follows:Beginning Inventory 10 pairs @ P20 = P200January 6 Purchase 4 pairs @ 25 = 100January 10 Sale 5 pairsJanuary 15 Purchase 7 pairs @ 30 = 210January 20 Sale 10 pairsJanuary 25 Purchase 4 pairs @ 30 = 120 How much is the Cost of Goods Sold using Average Cost Periodic? a. 378 b. 358 c. 265 d. 236
Determine the missing elements of the Income Statement. Replace the letters with your answers.The partial income statements of five different companies are as follows: 12345 Net SalesAD250,000290,000400,000 Merchandise Inventory, 1/1/2020B50,00070,000J120,000 Net Cost of Purchases80,000EG160,000390,000 Goods Available for Sale110,000160,000HKM Merchandise Inventory, 1/1/202040,000F30,00070,000N Cost of Goods SoldC140,000230,000L380,000 Gross Profit50,00040,000I160,000O
Using the following information, what is the amount of gross profit? Purchases$44,000Merchandise inventory, September 16,600Selling expense1,550Merchandise inventory, September 307,100Sales94,000Interest expense1,240Administrative expense1,110Rent revenue2,200
Below is a series of cost of goods sold sections for companies B, M, O, and S. Fill in the lettered blanks to complete the cost of goods sold sections. B M O S Beginning inventory $ 305 $ 146 $ 854 $enter a dollar amount (j) Purchases 1,830 1,318 enter a dollar amount (g) 53,180 Purchase returns and allowances 98 enter a dollar amount (d) 354 enter a dollar amount (k) Net purchases enter a dollar amount (a) 1,269 9,040 51,594 Freight-in 159 enter a dollar amount (e) enter a dollar amount (h) 2,733 Cost of goods purchased enter a dollar amount (b) 1,501 9,821 enter a dollar amount (l) Cost of goods available for sale 2,196 1,647 enter a dollar amount (i) 60,427 Ending inventory 378 enter a dollar amount (f) 1,403 7,601 Cost of goods sold enter a dollar amount
UMET's Stores had the following inventory transactions in 2020: Transaction Units Cost per unit 1/1 Balance 50 $6 2/14 Sale 25 5/23 Purchase 100 8 8/21 Sale 50 11/5 Purchase 25 12 11/18 Sale 95 Required: Compute tge cost of goods sold and the ending inventory using the periodic inventory system for each of the following cost flow assumptions: a. FIFO b. LIFO c. Weighted average

SEE MORE QUESTIONS

Recommended textbooks for you

Survey of Accounting (Accounting I)

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS