Question: Please do question in excel and not on paper, thanks! 107 10. 108 Given the following information calculate: 109 A. The closing book inventory at

Please do question in excel and not on paper, thanks! 107

Please do question in excel and not on paper, thanks!

107 10. 108 Given the following information calculate: 109 A. The closing book inventory at cost: 110 B. The gross cost of merch sold: 111 Cost Retail 112 opening inventory $65,250.00 $145,000.00 113 gross purchases $51,750.00 $115,000.00 114 returns to vendors $9,000.00 $20,000.00 115 additional markup $2,000.00 116 freight $3,000.00 117 total merch handled CMU = 118 net sales $95,000.00 cost % = 19 net markdowns $18,000.00 20 employee discounts $2,000.00 21 total retail deductions 22 closing book inventory 23 gross cost of merch sold + 24

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please do this in excel and not on paper, thanks! 60 20 51 Given the following information, calculate the gross cost of merchandise sold: Cost Retail 52 53 opening inventory $164,250.00 $365,000.00...

The handbag department received 432 totes for the spring season. At the end of the first month, 280 totes were on hand. What was the sell-through percent of the totes? Note: round percent to two...

81 82 9. 465,000.00 475,000.00 370,000.00 353,000.00 83 Given the following conditions determine: 84 A. Is there an inventory shortage or overage? 85 B. The inventory shortage or overage %: Retail...

Please do question in excel and not on paper, thanks! % Percent 0. Retail $80,000.00 $65,000.00 $12,000.00 $30,000.00 2.133 128 12. -0 129 Given the following information calculate: 130 A. inventory...

Please do question in excel and not on paper, thanks! ul 41 42 6. 43 Calculate the closing book inventory given the following information: 44 Retail 45 opening inventory $150,000.00 4.46 gross...

Please do question in excel and not on paper, thanks! 65 5. 70 66 Calculate the total merchandise handled given the following information. 67 You may not need all of the information you have been...

I need help with these questions. I will pay $30. This submission limit to $8 only. Can I get by tomorrow noon. 11/16/2017.Please provide excel with calculations Question 2 Assume that you are...

Please do question in Excel and not on paper, Thanks! 86 87 9. 88 Given the following conditions determine: 89 A. Is there an inventory shortage or overage? 90 B. The inventory shortage or overage %:...

105 110 111 Retail $145,000.00 $115,000.00 $20,000.00 106 10. 107 Given the following information calculate: 108 A. The closing book inventory at cost: 109 B. The gross cost of merch sold: Cost...

Please do in Excel and not on paper, Thanks! Retail $80,000.00 $65,000.00 $12,000.00 $30,000.00 146 147 13 148 Given the following information calculate: Value 149 B. gross cost of merch sold: 150...

Total revenue will increase if price Select one: Decreases Decreases over the elastic portion of the demand curve Increases or decreases over any portion of the demand curve Increases over the...

Analyze the data of Exercise 16.1 by using the signed-rank test.

I also need to know how to solve for the historical cost of the Equipment as well as the Furniture

The following information is available for Yancey Company: Assume that Yancey uses a periodic inventory system and that there are 700 units left at the end of the month. Compute the cost of erding...