Question

USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 19 - 22 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis balls from the Questor Company and markets the balls under the Devlin brand name. Devlin started operations on January 1, 2016. In the table below, Quarter 1 represents the time period from January 1, 2016 to March 31, 2016 and Quarter 2 represents the time period from April 1, 2016 to June 30, 2016. Devlin began operations on January 1, 2016 with no inventory Purchases and sales data for Devlins first two quarters of business are shown below 26,000 cartons at $37 per carton Sales Purchases January February 5,000 cartons at S12 10,000 cartons at S16 15,000 cartons at S18 uarter Sales 63,000 cartons at $45 per carton April May June 16,000 cartons at S20 18,000 cartons at S24 26,000 cartons at S30 19. Calculate the Quarter 2 ending inventories in dollars) using the LIFO inventory valuation method. 20. Calculate Quarter 2 GROSS PROFIT using the LIFO inventory valuation method. 21. Calculate the Quarter 2 ending inventories (in dollars) using the FIFO inventory valuation method. 22. Calculate Quarter 2 GROSS PROFIT using the FIFO inventory valuation method.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. в 1 프· ー· 鱼, Δ. :r-ㄧ 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Editing Format Painter Clipboard Alignment Number Cells BK1 BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW QUARTER 1 UNDER LIFO METHOD, EARLIER PURCHASES WILL BE CONSUMED LAST SO MARCH 15000 UNITS WILL BE SOLD FIRST AND SO ON 4 UNITS SOLD 26000 PURCHASE IN MARCH = 15000 PURCHASE IN FEB =10000 PURCHASE IN JAN 5000 TOTAL SOLD RATE 15000 10000 1000 26000 18 16 12 6 10 CLOSING STOCK FOR QUARTER 1 CLOSING STOCK FOR QUARTER 1 (S) 000 (5000-1000) 48000 4000#12 12 13 14 15 16 17 18 19 | FIFO . CASH BUDGET BV MV ratio VARIANCE BEP, OL FL ratios B-S loss SALES BUDGET DIFF ANALYSIS overheadfloat 1 45Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Paste Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. Styles ▼ ㆆ ▼ Clipboard Font Alignment Number Cells BR27 BJ BK BL BM BN BO BP BQ BR BS BT BU BV 13 14 15 16 17 18 19 20 21 QUARTER2 UNITS SOLD 63000 PURCHASE IN JUNE 26000 PURCHASE IN MAY 18000 PURCHASE IN APR 16000 USED FROM CLOSING STOCK OF QUARTER 1 TOTAL SOLD RATE COST OF GOODS SOLD 26000 18000 16000 3000 63000 30 780000 24 432000 20 320000 12 36000 1568000 19 SO CLOSING INVENTORY FOR QUARTER 2 CLOSING INVENTORY FOR QUARTER 1 - USED IN QUARTER2 4000-3000 1000 23 24 25 26 27 28 29 30 31 CLOSING INVENTORY FOR QUARTER 2 = CLOSING INVENTORY FOR QUARTER 2 (S) 12000 (1000*12) 20 GROSS PROFIT FOR QUARTER 2 SALES-63000 X 45 2835000 1568000 1267000 LESS COGS GROSS PROFIT = | FIFO , CASH BUDGET BV MV ratio VARIANCE BEP, OL FLratios B-S loss SALES BUDGET DIFF ANALYSIS overheadfloat 06:33File Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Calibri ー E ゴWrap Text General ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard BL32 BJ Font Alignment Number Styles Cells BK BL BM BN BO BP BQ BR BS BT BU 32 QUARTER 1 UNDER FIFO METHOD, LAST PURCHASES WILL BE CONSUMED LAST SO JAN 5000 UNITS WILL BE SOLD FIRST AND SO ON 34 35 36 37 38 39 40 41 42 43 UNITS SOLD-26000 PURCHASE IN JAN-5000 PURCHASE IN FEB-10000 PURCHASE IN MARCH 15000 TOTAL SOLD RATE 5000 10000 11000 26000 12 16 18 CLOSING STOCK FOR QUARTER 1 CLOSING STOCK FOR QUARTER 1 (S) 4000 (15000 -11000) 72000 4000 18 45 46 47 48 49 50 | FIFO , CASH BUDGET 45 BV MV ratio VARIANCE BEP, OL FLratios B-S loss SALES BUDGET DIFF ANALYSIS overheadfloat 06:35Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text General ta copy. B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard BK63 BJ Font Alignment Number Styles Cells BK BL BM BN BO BP BQ BR BS BT BU BV 45 46 47 48 49 50 51 52 53 54 QUARTER2 UNITS SOLD 63000 PURCHASE IN APR = 16000 PURCHASE IN MAY 18000 PURCHASE IN JUNE 26000 USED FROM CLOSING STOCK OF QUARTER 1 TOTAL SOLD RATE COST OF GOODS SOLD 16000 18000 26000 3000 63000 20 320000 24 432000 30 780000 1854000 1586000 SO CLOSING INVENTORY FOR QUARTER 2 = CLOSING INVENTORY FOR QUARTER 1-USED IN QUARTER 2 CLOSING INVENTORY FOR QUARTER 2 = 4000-3000 1000 21 CLOSING INVENTORY FOR QUARTER 2 (S)- 56 57 58 59 60 61 62 63 44 FIFO CASH BUDGET 18000 (1000 18) GROSS PROFIT FOR QUARTER 2 SALES = 63000 X 45 = COGS GROSS PROFIT = 2835000 1586000 1249000 ESS BV MV ratioVARIANCE BEP, OL FLatios B-S loss SALES BUDGET DIFF ANALYSIS overheadfloat

Add a comment
Know the answer?
Add Answer to:
USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 19 - 22 The Devlin Corporation, a diversified distribution...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please Answer questions 19-22 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis...

    Please Answer questions 19-22 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis balls from the Questor Company and markets the balls under the Devlin brand name. Devlin started operations on January 1, 2016. In the table below, Quarter 1 represents the time period from January 1, 2016 to March 31, 2016 and Quarter 2 represents the time period from April 1, 2016 to June 30, 2016. Devlin began operations on January 1, 2016 with no inventory...

  • Could you confirm my answers, please? USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 19 -22 The...

    Could you confirm my answers, please? USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 19 -22 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis balls from the Questor Company and markets the balls under the Devlin brand name. Devlin started operations on January 1, 2016. In the table below, Quarter 1 represents the time period from January 1, 2016 to March 31, 2016 and Quarter 2 represents the time period from April 1, 2016 to June 30,...

  • UOLIUL TULLUMUTURIIUTIUNILILULIII122 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis balls from...

    UOLIUL TULLUMUTURIIUTIUNILILULIII122 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis balls from the Questor Company and markets the balls under the Devlin brand name. Devlin started operations on January 1, 2019. In the table below, Quarter 1 represents the time period from January 1, 2019 to March 31, 2019 and Quarter 2 represents the time period from April 1, 2019 to June 30, 2019. Devlin began operations on January 1, 2019 with no inventory. Purchases and...

  • PLEASE EXPLAIN ALL STEPS ON HOW YOU GOT TO EACH ANSWER, VERY APPRECIATED! USE THE FOLLOWING...

    PLEASE EXPLAIN ALL STEPS ON HOW YOU GOT TO EACH ANSWER, VERY APPRECIATED! USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 19 -22 The Devlin Corporation, a diversified distribution company, purchases cartons of canned tennis balls from the Questor Company and markets the balls under the Devlin brand name. Devlin started operations on January 1, 2016. In the table below, Quarter 1 represents the time period from January 1, 2016 to March 31, 2016 and Quarter 2 represents the time period...

  • Danone is a wholesale distribution business that sells a soybean drink product to supermarkets. The following...

    Danone is a wholesale distribution business that sells a soybean drink product to supermarkets. The following relates to the business's activities during January 2020: January 1 Opening inventory 40,000 cartons - cost $3 per carton Purchases 20,000 cartons - purchase price $3.50 per 8 carton 23 Purchases 30,000 cartons – purchase price $3.60 per carton 31 Closing inventory (as per physical stocktake) 44,000 cartons Additional information i. The most recent selling price of the soybean drink is $6.50 per carton...

  • Please answer from 34 to 40. Error Question 38* instead of Question 35 USE THE INFORMATION...

    Please answer from 34 to 40. Error Question 38* instead of Question 35 USE THE INFORMATION BELOW TO ANSWER THE QUESTIONS 34 - 40 Purchases of inventory and sales information for the Baker Company (a retailer) are summarized below by quarter. Assume Baker Company began operations on January 1, 2019 (with zero inventory): Month Purchases in Units Cost per Unit January 14.000 $10 February 5,000 $10 March 3,000 $12 Quarter 1 sales = 14,000 units at $20 per unit April...

  • Use the following information for the Exercises below. [The following information applies to the questions displayed...

    Use the following information for the Exercises below. [The following information applies to the questions displayed below.]    Hemming Co. reported the following current-year purchases and sales for its only product.      Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 290 units @ $13.60 = $ 3,944 Jan. 10 Sales 260 units @ $43.60 Mar. 14 Purchase 500 units @ $18.60 = 9,300 Mar. 15 Sales 430 units @ $43.60 July 30 Purchase 490...

  • Required information (The following information applies to the questions displayed below.) Hemming Co. reported the following...

    Required information (The following information applies to the questions displayed below.) Hemming Co. reported the following current-year purchases and sales for its only product. Units Sold at Retail 160 units @ $41.20 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Mar. 14 Purchase Mar. 15 Sales July 30 Purchase Oct. 5 Sales Oct. 26 Purchase Totals Units Acquired at Cost 230 units @ $11.20 = $ 2,576 350 units @ $16.20 = 5,670 430 units @ $21.20 - 9,116...

  • Required Information Use the following information for the Exercises below. [The following Information applies to the...

    Required Information Use the following information for the Exercises below. [The following Information applies to the questions displayed below.] Hemming Co. reported the following current-year purchases and sales for its only product. Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Mar. 14 Purchase Mar. 15 Sales July 30 Purchase Oct. 5 Sales Oct. 26 Purchase Totals Units Acquired at Cost Units Sold at Retail 200 units@ $10 = $ 2,800 150 units @ $40 350 units@ $15 = 5,250...

  • Use the following to answer questions 7-17 During September, KM Company sells 9,800 watches for $300.00...

    Use the following to answer questions 7-17 During September, KM Company sells 9,800 watches for $300.00 each. The company has the following inventory purchase transactions for September: # of Units 300 Date 1-Sep 4-Sep 24-Sep Transaction Beginning Inventory Purchase Purchase Unit cost $195.00 $198.00 $200.00 6,000 3,700 10,000 Total Cost $58,500 1,188,000 740,000 $1,986,500 7. $ _What were company's sales for the period? For questions 8 - 10 assume the company uses First-in, First-out (FIFO) inventory valuation. 8. $ 9....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT