Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in the following graph based off the information: FactSheet - Data on 2019 Financial Year Jan-2019 Oct-2019 180 Feb-2019 189 107 Sales Volume -
Fill in the following graph based off the information:
FactSheet - Data on 2019 Financial Year Jan-2019 Oct-2019 180 Feb-2019 189 107 Sales Volume - Sunglasses Sales Volume - Prescription glasses Service Volume - No. of Eye-tests Mar-2019 164 112 102 161 Apr-2019 174 100 91 May-2019 164 111 101 Jun-2019 217 185 168 Jul-2019 212 178 162 Aug-2019 191 143 Sep-2019 131 129 Nov-2019 176 169 154 Dec-2019 189 176 160 101 123 112 92 97 130 117 Selling Price - Sunglasses Cost Price - Sunglasses $ $ 200.00 60.00 Selling Price - Prescription glasses Cost Price - Prescription glasses $ $ 150.00 80.00 Service Revenue per eye-test $ 75.00 Number of Sale Assistants: Wage Rate per Employee per Month 2 4,000 $ Number of Office Staff: Wage Rate per Employee per Month 1 4,500 $ 2 Number of Optometrists Wage Rate per Employee per Month $ 6,500 Additional Information: Both James and Olivia are owners within the business and each of them draws an amount of $1784 per month. Each owner plans on increasing the drawings to $3568 month starting from January of 2021. As the manager, James keeps a close eye on inventory management and would like to always maintain a monthly ending inventory requirement of 30% of next month's sales. You can assume the beginning inventory for Jan 2021 to be o units for both sunglasses and prescription glasses. All purchases of inventory with the current supplier are on a credit basis, with 70% of the amount settled in the same month of purchase and the remaining 30% settled one month after the month of purchase. You can assume that all credit amounts for purchase of inventory prior to January 2021 have been settled. The business typically will have 80% of their sales of sunglasses and prescription glasses as cash, with the remaining 20% on credit. Of the credit sales, 70% is collected in the month of sales, 20% is collected one month after the sales, and 10% is collected two months after the sales. You can assume that all credit amounts for sale inventory prior to January 2021 have been settled All customers coming in for an eye-test pay for the service in cash 100% of the time. The business has the following non-current assets: In 2019, the business purchased specialised optometry equipment to provide comprehensive eye-tests. The total cost of equipment is $13620 and it is expected to last 5 years. Other office equipment has a total cost of $30480 and depreciates at 20% per annum. Shop Fittings were originally purchased at $64920 and depreciate at 10% per annum. All non-current assets have $0 residual value and are depreciated using the straight-line method of depreciation. Other Fixed Costs: Marketing expense of $900 per annumis paid evenly across 12 months. $3000 of general business insurance is paid in July every year. This insurance covers the period 1st Jan to 31st Dec every year. (100% office) Bank fees works out to be $48 per month and are paid at the start of each quarter. On average, the office supplies are purchased, paid and expensed every month to the amount of $90. General council rates are $792 per year and are usually paid in December every year. The rates cover the period 1st Jan to 31st Dec every year. (50% store: 50% office) Rent is paid at the start of each quarter and works out to be $6400 per month. (80% store: 20% office) Water, gas and electricity are combined under utility expense which adds up to $510 per quarter and is usually paid at the end of each quarter. (75% store: 25% office) "Note: Quarter 1 runs from 1 Jan-31 Mar; Quarter 2 runs from 1 Apr - 30 Jun; Quarter 3 runs from 1 Jul - 30 Sep: Quarter 4 runs from 10ct - 31 Dec. Sales Budget Jan-21 180.0 Feb-21 189.0 200.0 $ 37,800.0 $ Expected Sales x Selling Price per Unit Sales Revenue ($) Mar-21 164.0 200.01$ 32,800.0 $ Apr-21 174.0 200.0 $ 34,800.0 $ May-21 164.0 200.0 IS 32,800.0 $ Jun-21 217.0 200.0 $ 54,200.0 $ Jul-21 212.0 200.01$ 42,400.0 $ Aug-21 191.0 200.01$ 38,200.0 S Sep-21 131.0 200.0 $ 26,200.0 $ Sunglasses Oct-21 161.0 200.0 $ 32,200.0 $ Nov-21 176.0 200.01$ 35,200.01$ Dec-21 189.00 200.0 $ 37,800.01$ TOTAL 2148.0 200.0 440,400.0 $ $ 200.0 $ 36,000.01$ 1634.0 Prescription Glasses Expected Sales x Selling Price per Unit Sales Revenue ($) 101.0 150.0 IS 15,150.0 ($ $ $ 107.0 150.01 $ 16,050.0 $ 112.0 150.01$ 16,800.0 $ 100.0 150.0 $ 15,000.01$ 111.0 150.0 $ 16,650.0 ($ 185.0 150.0 $ 27,750.0 $ 178.0 150.0$ 26,700.0 ($ 143.0 150.0 $ 21,450.0 ($ 129.0 150.0$ 19,350.0 ($ 123.0 150.01$ 18,450.0 S 169.0 150.0 $ 25,350.0 $ 176.01 150.0 $ 26,400.0 $ 150.0 245,100.0 TOTAL Sales Revenue ($) 112.0 154.0 Eye-Tests Expected Sales x Selling Price per Unit TOTAL Service Revenue ($) $ $ 92.0 75.0$ 6,900.0 $ 97.0 75.01 $ 7,275.0 $ 102.0 75.0 $ 7,650.0 ($ 91.0 75.0 I $ 6,825.0$ 101.0 75.0 $ 7,575.0 IS 168.0 75.0 $ 12,600.0 $ 162.0 75.0 $ 12,150.01$ 130.0 75.01 $ 9,750.0$ 117.0 75.0 $ 8,775.0 ($ 75.01 $ 8,400.0 $ 75.0 $ 11,550.0 ($ 160.00 75.0 $ 12,000.01$ 1486.0 75.0 111,450.0 Cost of Sales Budget Jan-21 180.0 60.01$ 10,800.01$ Expected Sales x Cost Price per Unit Cost of Sales ($) Feb-21 189.0 60.0 I $ 11,340.0 $ Mar-21 164.0 60.01$ 9,840.01$ Apr-21 174.0 60.01$ 10,440.0 $ May-21 164.0 60.0 IS 9,840.0 $ Jun-21 217.0 60.0 I $ 13,020.0 $ Jul-21 212.0 60.01$ 12,720.01$ Aug-21 191.0 60.01$ 11,460.01$ Sep-21 131.0 60.0 $ 7,860.01$ Oct-21 161.0 60.0 $ 9,660.01$ Nov-21 176.0 60.01$ 10,560.01$ Dec-21 189.01 60.01$ 11,340.0$ TOTAL 2148.0 60.0 128,880.0 Sunglasses $ $ Prescription Glasses Expected Sales x Cost Price per Unit Cost of Sales ($) $ $ 101.0 80.01$ 8,080.01$ 107.0 80.01$ 8,560.0 ($ 112.0 80.0 $ 8,960.01$ 100.0 80.0 $ 8,000.0 ($ 111.0 80.01$ 8,880.01$ 185.0 80.01$ 14,800.0 $ 178.0 80.01$ 14,240.01$ 143.0 80.01$ 11,440.0 $ 129.0 80.01$ 10,320.01$ 123.0 80.01$ 9,840.0 $ 169.0 80.01$ 13,520.0$ 176.01 80.0 IS 14,080.0 ($ 1634.0 80.0 130,720.0 TOTAL Cost of Sales (6) $ 18,880.0'S 19,900.0 '$ 18,800.0 '$ 18,440.0 '$ 18,720.0 '$ 27,820.0 $ 26,960.0 '$ 22,900.0 '$ 18,180.0'S 19,500.0 '$ 24,080.0 '$ 25,420.0 '$ 259,600.0 Purchases Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 180.0 189.0 164.0 174.0 164.0 217.0 212.0 191.0 131.0 161.00 61.0 176.0 189.0 Expected Sales (Sunglasses) add: Ending Inventory Requirement Total Units Required: 56.7 49.2 52.2 49.2 65.1 63.6 57.3 39.3 48.3 52.8 56.7 0.01 236.7 238.2 216.2 223.2 229.1 280.6 269.3 230.3 179.3 213.8 232.7 189.0 Sunglasses 0.0 56.7 49.2 52.2 49.2 65.1 65.1 63.6 57.3 39.31 48.3 52.8 56.7 236.7 181.5 167.0 171.0 179.9 215.5 205.7 173.0 140.0 265.5 179.9 132.3 less: Beginning Inventory Total Purchase Units: x Cost ($) per Unit Total Purchase Cost ($) $60.0 $60.0 $60.0 $60.0 $60.0 $60.0 $60.00 $60.0 $60.0 $60.0 $60.0 $60.0 $14,202.0 $10,890.0 $10,020.0 $10,260.0 $10,794.0 $12,930.00 $12,342.0 $10,380.0 $8,400.0 $15,930.0 $10,794.0 $7,938.0 101.0 107.0 112.0 100.0 111.0 185.0 178.0 143.0 129.0 123.0 169.00 176.0 32.1 33.6 30.0 33.3 55.5 53.4 42.9 38.7 36.9 50.71 52.8 0.00 133.1 140.6 142.0 133.3 166.5 238.4 220.9 181.7 165.9 173.7 221.8 176.0 Prescription Glasses Expected Sales (Prescription Glasses) add: Ending Inventory Requirement Total Units Required: less: Beginning Inventory Total Purchase Units: x Cost ($) per Unit Total Purchase Cost ($) 0.0 32.1 33.6 30.0 33.3 55.5 53.4 42.9 38.7 36.9 50.7 52.8 133.1 108.5 108.4 103.3 133.2 182.9 167.5 148.8 127.2 136.8 171.1 123.2 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $80.0 $10,648.0 $8,680.0 $8,672.0 $8,264.0 $10,656.0 $14,632.0 $13,400.0 $11,904.0 $10,176.0 $10,944.0 $13,688.0 $9,856.0 Total Overall Purchase Cost ($) $24,850.0 $19,570.0 $18,692.0 $18,524.0 $21,450.0 $27,562.00 $25,742.0 $22,284.0 $18,576.0 $26,874.0 $24,482.0 $17,794.0 Selling, General, and Administrative Expense Budget Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 TOTAL Selling Expenses Total Selling Expenses General & Administrative Expenses Total General & Admin. Expenses Total Selling, General & Administrative ExpensesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started