Photo AI

INVENTORY VALUATION George Grande is the majority shareholder and CEO of Grande Ltd - NSC Accounting - Question 3 - 2019 - Paper 1

Question icon

Question 3

INVENTORY-VALUATION--George-Grande-is-the-majority-shareholder-and-CEO-of-Grande-Ltd-NSC Accounting-Question 3-2019-Paper 1.png

INVENTORY VALUATION George Grande is the majority shareholder and CEO of Grande Ltd. The company supplies hotels with cabinets and lamps. The periodic system is us... show full transcript

Worked Solution & Example Answer:INVENTORY VALUATION George Grande is the majority shareholder and CEO of Grande Ltd - NSC Accounting - Question 3 - 2019 - Paper 1

Step 1

3.1 Calculate the value of closing stock for cabinets on 30 September 2019 using the first-in-first-out method.

96%

114 rated

Answer

To calculate the closing stock using FIFO, we consider the earliest purchases first. If there are 280 units in total, we take the first 230 units at the cost of $302,500 to find the closing stock value.

Step 2

3.2.1 Calculate the % mark-up achieved in 2019.

99%

104 rated

Answer

The % mark-up is calculated using the formula: ext{Mark-up ext (%) = } rac{ ext{Sales} - ext{Cost}}{ ext{Cost}} imes 100 Given that sales were 3,480,000andcost3,480,000 and cost 2,170,500, we find: ext{Mark-up ext (%) = } rac{3,480,000 - 2,170,500}{2,170,500} imes 100 ext{ = 60.3%}

Step 3

3.2.2 Provide TWO points (with figures) to prove that this decision achieved its aims.

96%

101 rated

Answer

  1. Sales increased from 3,375,000to3,375,000 to 3,480,000, demonstrating a $105,000 increase, equating to an increase of 3.1%.
  2. The number of customers grew from 26 to 37, a notable increase of 42%.

Step 4

3.2.3 The CEO feels that this decision also negatively affected the company. Provide TWO points (with figures) to support his opinion.

98%

120 rated

Answer

  1. The gross profit decreased from 1,309,500to1,309,500 to 2,170,500; this is a reduction of $115,500 or 8.1% in profit margin.
  2. The average selling price per customer dropped from 2.5 to 2.320, or a decline of 7.2%.

Step 5

Give the directors advice to solve this problem. Explain TWO points.

97%

117 rated

Answer

  1. Restrict trade discounts to loyal customers only to enhance profit margins.
  2. Increase marketing efforts, targeting areas beyond current market reach to boost sales.

Step 6

3.3 Calculate the stockholding period for lamps (use closing stock).

97%

121 rated

Answer

The stockholding period is calculated as: ext{Stockholding Period = } rac{ ext{Average Stock}}{ ext{Cost of Sales}} imes 365 Given Average Stock of 59,625andcostofsalesof59,625 and cost of sales of 930,375, we find: = rac{59,625}{930,375} imes 365 ext{ days} ext{ = 23.4 days}

Step 7

3.4 Calculate the number of missing lamps.

96%

114 rated

Answer

The missing lamps can be calculated as: ext{Missing Lamps = Opening Stock + Purchases - Closing Stock - Sales Using 600+600 + 300 - 265265 - 3,675, ext{ we find that there are } 460 ext{ missing lamps.} $$

Step 8

Give TWO suggestions to solve this problem.

99%

104 rated

Answer

  1. Implement stricter controls and regular audits to manage stock.
  2. Utilize CCTV for better inventory oversight.

Step 9

3.5 Calculate the value of the closing stock of TV sets on 30 September 2019 using the specific identification method.

96%

101 rated

Answer

For LYN TV sets, the valuation is: 7,800,000 - 2,580,000 = 5,220,000.
For KYA TV sets, the valuation is: 440,000 - 388,000 = 62,000.
The total value of closing stock on 30 September 2019 is $11,772,000.

Step 10

3.6 Explain THREE different concerns that George would have about this problem.

98%

120 rated

Answer

  1. The risk of overstocking could lead to increased holding costs.
  2. Potential loss of revenue due to defective stock might impact customer satisfaction.
  3. Difficulty in tracking sales leads to inaccuracies in financial reporting.

Join the NSC students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;