Items Refer to the Workshop 2 Help-sheet if you need detailed help to create new items....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Items Refer to the Workshop 2 Help-sheet if you need detailed help to create new items. Item code Item name SKU112820 Road Bikes SKU112821 Commuter & Recreation Bikes SKU112822 Mountain Bikes SKU112823 Cyclocross Bikes SKU112824 Folding Bikes SKU112825 Touring Bikes SKU112826 BMX Bikes SKU112827 Cruiser Bikes Buy price Sell price (Incl. GST) (Incl. GST) $849.00 $1,599.00 $1,698.00 $3,198.00 $859.00 $1,718.00 $1,199.00 $2,398.00 $549.00 $1,098.00 $178.00 $359.90 $198.00 $399.90 $799.00 $1,598.00 Further Information Salaries expense Warehouse rent expense $25,000 per month $2,420 per month incl. GST Telecommunication expense $748 per month incl. GST Allowance for doubtful debts 10% of the Accounts Receivable Provision for warranty 5% of the sales revenue Interest expense on loan (Building Head Office) Calculated at 8% per annum Delivery Van Store Building Fire insurance Purchased on 1 July 2019 at $88,000 incl. GST, with a useful life of 5 years, and $8,000 residual value. It is depreciated using the straight-line method. Purchased on 1 July 2016, at $770,000 incl. GST with a useful life of 20 years, and $100,000 residual value. It is depreciated using the straight-line method. On 1st July 2020, you paid $39,600 incl. GST for a twelve-month fire insurance policy to Berkshire Group. Date 1 September 1 September 1 September 1 September 1 September Details You borrowed $104,000 from the Northern Bank on a short-term loan. The money is to be used to purchase welding machinery. The principle, plus 7.5% annual interest, will be paid in 3 months. You purchased 20 items of SKU112820, 10 SKU112821, 15 SKU112822, and 12 SKU112823 from Focus Bikes. You received all the stocks ordered and paid 20% of the purchase price together with the freight of $253 incl. GST. You agreed to pay Focus Bikes the balance on 5th October. You paid $11,440 incl. GST for a three-month product liability insurance policy to Society Insurance. You received $46,750 incl. GST cash in advance from clients for a one-year subscription to your company featured magazine, "RideOn". You received $76,560 incl. GST in advance from Gocycle for repair of bicycles. 2 September 2 September 3 September 4 September You spent $1,496 incl. GST on miscellaneous office supplies at Officeworks. You paid for these from your bank account. Consider purchase of supplies as a prepaid supplies account. You spent $102,850 incl. GST on a welding machinery and paid for it by using your bank account. You estimate that the machinery will have a useful life of 5 years, during which you are planning to produce 40,000 units of new bike pedals. The residual value of the machinery is $13,500. Actual number of units of pedals that will be produced within the next twelve months will be 2,400 units. Record the purchased of machinery on this date. Note that the trial Company in Xero does not allow you to add an asset to the register or create asset types as we did in Demo Company in Week 6 so you'll need to just record this transaction as an asset purchase. You sold 40 SKU112820 and 20 SKU112822 to Ideal Bikes. Ideal Bikes paid you the full amount into your bank account. You sold 80 SKU112826 and 60 SKU112825 to Road Riders. Road Riders paid you a deposit of 75% of the total sale into your bank account and agreed to pay the remaining 25% on 4th October. Date 6 September 6 September 7 September Details You spent $5,500 incl. GST on a computer at Digi-Com and paid for it from your bank account. You estimate it will have a useful life of 3 years and be worth $713.61 at the end of the 3 years. Computer is depreciated using the diminishing balance method and the rate of depreciation is 41%. Record the purchase of the computer on this date. You transferred surplus cash out of the Bank Account to an Investment Account. You realised that you don't need all your capital sitting in the low interest working bank account so have transferred $70,000 into a higher interest-bearing account. Record this movement in a journal entry. This account will pay you 2.5% interest per annum, credited monthly on the 6th of each month into your account. You sold 40 SKU112822 and 60 SKU112823 Road Eagles on account, term 2/8, n/30. 8 September 9 September 10 September 10 September 10 September 10 September 11 September You purchased 25 SKU112824, 15 SKU112825, and 15 SKU112827 on credit from Blissful Pedals. You sold 36 SKU112824 and 28 SKU112820 to Urban Tour. Urban Tour paid you a deposit of 85% of the total sale into your bank account and agreed to pay the remaining 15% on 16th October. You sold 30 SKU112821 and 40 SKU112825 to Just Cycles. Just Cycles paid you a deposit of 75% of the total sale into your bank account and agreed to pay the remaining 25% on 10th October. You received $8,192 credit (incl. GST) for damaged items including 4 SKU112820 and 4 SKU112823 returned to Focus Bikes. You sold 40 SKU112823 and 48 SKU112827 to Champion Wheels. Champion Wheels paid you a deposit of 90% of the total sale into your bank account and agreed to pay the remaining 10% on 27th September. You opened an account with Apache Petrol to pay for fuel for the delivery van. You sold 20 SKU112820 to Bicycle Workshop on account. Bicycle Workshop agreed to pay the amounts due on 12 September 2020. Date 13 September 14 September 15 September 16 September Details You sold 60 SKU112822, 60 SKU112825 and 30 SKU112827 to The Cycle Gear. The Cycle Gear paid you a deposit of 85% of the total sale into your bank account and agreed to pay the remaining 15% on 25th September. You received the full payment less discount from Road Eagles for their purchase on 7th September. You paid Ad Ready $7,959.6 incl. GST for online advertisements. These ads will run over the next 3 months, with an end date of 15th December 2020. You sold 30 SKU112825 and 30 SKU112827 to Bike Gallery. Bike Gallery paid you the full amount into your bank account. 17 September 17 September 17 September 18 September 18 September You sold 20 SKU112821 and 24 SKU112825 to Bike & Run. Bike & Run paid you a deposit of 90% of the total sale into your bank account and agreed to pay the remaining 10% on 22 September. You paid an invoice for the current period's fuel bill of $165 incl. GST from Apache Petrol plus 1% transaction fee. Transaction fee includes GST. Paid Blissful Pedals in full for the purchase on 8th September. After several attempts to collect receivables from Bicycle Workshop you finally write off Bicycle Workshop accounts as bad. You received 90% of the receivables from Bike Friday. Bike Friday agreed to pay the remaining 10% on 18 October. Date 20 September 20 September 21 September 22 September 23 September 24 September 24 September Details You sold 70 SKU112825 and 106 SKU112824 to Bike Town on account, term 3/10, n/30. You paid 35% of the accounts payable to Bike Works. You promised Bike Works to pay the remaining 65% on 20 October. You sold 80 SKU112822 and 100 SKU112820 to Buzz Bikes on account, term 2/10, n/30. You granted Buzz Bikes $10,308 credit (incl. GST) for 6 SKU112822 returned. You sold 20 SKU112822 and 60 SKU112821 to Rockrider. Rockrider paid you the full amount into your bank account. You sold 22 SKU112821 and 58 SKU112820 to Cycle City. Cycle City paid you a deposit of 85% of the total sale into your bank account and agreed to pay the remaining 15% on 16th October. You paid an invoice for this period's fuel bill of $165 incl. GST from Apache Petrol plus 1% transaction fee. Transaction fee includes GST. Date 27 September 27 September 28 September 28 September 28 September Details You sold 30 SKU112822 and 60 SKU112820 to Bike Lane on account, term 3/6, n/30. You received the full payment less discount from Bike Town for their purchase on 20th September. You granted Bike Lane $8,590 credit Incl. GST for 5 SKU112822 returned. You sold 80 SKU112820 and 24 SKU112823 to Race Time. Race Time paid you the full amount into your bank account. You paid $4,235 cash to satisfy warranty claims on faulty products. 29 September 29 September 29 September 29 September 29 September 29 September You sold 40 SKU112822 to Bike Buddies. Bike Buddies paid you the full amount into your bank account. You sold 40 SKU112824 and 28 SKU112820 to Bike Palace. Bike Palace paid you a deposit of 90% of the total sale into your bank account and agreed to pay the remaining 10% on 8th October. You received the full payment from Buzz Bikes for the sales on 21st September, less discount. You received the full payment from Bike Lane for the sales on 27th September, less discount. You are informed that Bike Palace is gone into liquidation and as such you are not able to collect the remaining receivables from Bike Palace. You write off the remaining receivables as bad. You sold the computer that your purchased on 6 September for $4,500 cash incl. GST. Adjusting Journal Entries 30th September This is the final day of the calendar month, and your main task is to prepare the month end accounting entries. For any adjustments required you will need to prepare a general journal entry. The adjusting journals that you will need to enter are as follows - round to TWO decimal places: 1. Interest expense - short-term loan (Northern Bank). (0.25 marks) 2. Insurance expense - product liability insurance policy (Society Insurance). (0.25 marks) 3. First month of subscription revenue earned from the company featured magazine, "RideOn". (0.25 marks) 4. You completed 30% of repairs for Gocycle during September. (0.25 marks) 5. Office supplies on hand at 30th September is $275 incl. GST. (0.25 marks) 6. Depreciation expense - welding machinery, using the units of production method. (0.25 marks) 7. Interest earned at month end. (0.25 marks) 8. Record the adjusting entry for fuel bill payable of $165 incl. GST from Apache Petrol for the final period i.e., period 5. (0.25 marks) 9. Advertising expense amount for the month of September. (0.25 marks) 10. Provision for warranties is equal to 5% of sales. (0.25 marks) 11. You realise that the economy has significantly deteriorated which is observed through the number of customers' debts that are written off during this month. As such you decide to increase the allowance from 10% to 35% of the accounts receivable (as of 30th September 2020). Record the adjusting entry for the allowance for doubtful debts account at 30 September 2020. (0.5 marks) 12. Salaries expense accrued for September. (0.25 marks) 13. Warehouse rent expense accrued for September. (0.25 marks) 14. Depreciation expense Delivery Van, using the straight-line method. (0.25 marks) 15. Depreciation expense Store Building, using the straight-line method. (0.25 marks) 16. Interest expense accrued on the loan for Building of the Head Office. (0.25 marks) 17.40% of deliveries are performed during September. (0.25 marks) 18. Telecommunication accrued for September. (0.25 marks) 19. Insurance expense, Fire insurance. (0.25 marks) Note all month end adjusting journals must be dated 30 September 2020. Items Refer to the Workshop 2 Help-sheet if you need detailed help to create new items. Item code Item name SKU112820 Road Bikes SKU112821 Commuter & Recreation Bikes SKU112822 Mountain Bikes SKU112823 Cyclocross Bikes SKU112824 Folding Bikes SKU112825 Touring Bikes SKU112826 BMX Bikes SKU112827 Cruiser Bikes Buy price Sell price (Incl. GST) (Incl. GST) $849.00 $1,599.00 $1,698.00 $3,198.00 $859.00 $1,718.00 $1,199.00 $2,398.00 $549.00 $1,098.00 $178.00 $359.90 $198.00 $399.90 $799.00 $1,598.00 Further Information Salaries expense Warehouse rent expense $25,000 per month $2,420 per month incl. GST Telecommunication expense $748 per month incl. GST Allowance for doubtful debts 10% of the Accounts Receivable Provision for warranty 5% of the sales revenue Interest expense on loan (Building Head Office) Calculated at 8% per annum Delivery Van Store Building Fire insurance Purchased on 1 July 2019 at $88,000 incl. GST, with a useful life of 5 years, and $8,000 residual value. It is depreciated using the straight-line method. Purchased on 1 July 2016, at $770,000 incl. GST with a useful life of 20 years, and $100,000 residual value. It is depreciated using the straight-line method. On 1st July 2020, you paid $39,600 incl. GST for a twelve-month fire insurance policy to Berkshire Group. Date 1 September 1 September 1 September 1 September 1 September Details You borrowed $104,000 from the Northern Bank on a short-term loan. The money is to be used to purchase welding machinery. The principle, plus 7.5% annual interest, will be paid in 3 months. You purchased 20 items of SKU112820, 10 SKU112821, 15 SKU112822, and 12 SKU112823 from Focus Bikes. You received all the stocks ordered and paid 20% of the purchase price together with the freight of $253 incl. GST. You agreed to pay Focus Bikes the balance on 5th October. You paid $11,440 incl. GST for a three-month product liability insurance policy to Society Insurance. You received $46,750 incl. GST cash in advance from clients for a one-year subscription to your company featured magazine, "RideOn". You received $76,560 incl. GST in advance from Gocycle for repair of bicycles. 2 September 2 September 3 September 4 September You spent $1,496 incl. GST on miscellaneous office supplies at Officeworks. You paid for these from your bank account. Consider purchase of supplies as a prepaid supplies account. You spent $102,850 incl. GST on a welding machinery and paid for it by using your bank account. You estimate that the machinery will have a useful life of 5 years, during which you are planning to produce 40,000 units of new bike pedals. The residual value of the machinery is $13,500. Actual number of units of pedals that will be produced within the next twelve months will be 2,400 units. Record the purchased of machinery on this date. Note that the trial Company in Xero does not allow you to add an asset to the register or create asset types as we did in Demo Company in Week 6 so you'll need to just record this transaction as an asset purchase. You sold 40 SKU112820 and 20 SKU112822 to Ideal Bikes. Ideal Bikes paid you the full amount into your bank account. You sold 80 SKU112826 and 60 SKU112825 to Road Riders. Road Riders paid you a deposit of 75% of the total sale into your bank account and agreed to pay the remaining 25% on 4th October. Date 6 September 6 September 7 September Details You spent $5,500 incl. GST on a computer at Digi-Com and paid for it from your bank account. You estimate it will have a useful life of 3 years and be worth $713.61 at the end of the 3 years. Computer is depreciated using the diminishing balance method and the rate of depreciation is 41%. Record the purchase of the computer on this date. You transferred surplus cash out of the Bank Account to an Investment Account. You realised that you don't need all your capital sitting in the low interest working bank account so have transferred $70,000 into a higher interest-bearing account. Record this movement in a journal entry. This account will pay you 2.5% interest per annum, credited monthly on the 6th of each month into your account. You sold 40 SKU112822 and 60 SKU112823 Road Eagles on account, term 2/8, n/30. 8 September 9 September 10 September 10 September 10 September 10 September 11 September You purchased 25 SKU112824, 15 SKU112825, and 15 SKU112827 on credit from Blissful Pedals. You sold 36 SKU112824 and 28 SKU112820 to Urban Tour. Urban Tour paid you a deposit of 85% of the total sale into your bank account and agreed to pay the remaining 15% on 16th October. You sold 30 SKU112821 and 40 SKU112825 to Just Cycles. Just Cycles paid you a deposit of 75% of the total sale into your bank account and agreed to pay the remaining 25% on 10th October. You received $8,192 credit (incl. GST) for damaged items including 4 SKU112820 and 4 SKU112823 returned to Focus Bikes. You sold 40 SKU112823 and 48 SKU112827 to Champion Wheels. Champion Wheels paid you a deposit of 90% of the total sale into your bank account and agreed to pay the remaining 10% on 27th September. You opened an account with Apache Petrol to pay for fuel for the delivery van. You sold 20 SKU112820 to Bicycle Workshop on account. Bicycle Workshop agreed to pay the amounts due on 12 September 2020. Date 13 September 14 September 15 September 16 September Details You sold 60 SKU112822, 60 SKU112825 and 30 SKU112827 to The Cycle Gear. The Cycle Gear paid you a deposit of 85% of the total sale into your bank account and agreed to pay the remaining 15% on 25th September. You received the full payment less discount from Road Eagles for their purchase on 7th September. You paid Ad Ready $7,959.6 incl. GST for online advertisements. These ads will run over the next 3 months, with an end date of 15th December 2020. You sold 30 SKU112825 and 30 SKU112827 to Bike Gallery. Bike Gallery paid you the full amount into your bank account. 17 September 17 September 17 September 18 September 18 September You sold 20 SKU112821 and 24 SKU112825 to Bike & Run. Bike & Run paid you a deposit of 90% of the total sale into your bank account and agreed to pay the remaining 10% on 22 September. You paid an invoice for the current period's fuel bill of $165 incl. GST from Apache Petrol plus 1% transaction fee. Transaction fee includes GST. Paid Blissful Pedals in full for the purchase on 8th September. After several attempts to collect receivables from Bicycle Workshop you finally write off Bicycle Workshop accounts as bad. You received 90% of the receivables from Bike Friday. Bike Friday agreed to pay the remaining 10% on 18 October. Date 20 September 20 September 21 September 22 September 23 September 24 September 24 September Details You sold 70 SKU112825 and 106 SKU112824 to Bike Town on account, term 3/10, n/30. You paid 35% of the accounts payable to Bike Works. You promised Bike Works to pay the remaining 65% on 20 October. You sold 80 SKU112822 and 100 SKU112820 to Buzz Bikes on account, term 2/10, n/30. You granted Buzz Bikes $10,308 credit (incl. GST) for 6 SKU112822 returned. You sold 20 SKU112822 and 60 SKU112821 to Rockrider. Rockrider paid you the full amount into your bank account. You sold 22 SKU112821 and 58 SKU112820 to Cycle City. Cycle City paid you a deposit of 85% of the total sale into your bank account and agreed to pay the remaining 15% on 16th October. You paid an invoice for this period's fuel bill of $165 incl. GST from Apache Petrol plus 1% transaction fee. Transaction fee includes GST. Date 27 September 27 September 28 September 28 September 28 September Details You sold 30 SKU112822 and 60 SKU112820 to Bike Lane on account, term 3/6, n/30. You received the full payment less discount from Bike Town for their purchase on 20th September. You granted Bike Lane $8,590 credit Incl. GST for 5 SKU112822 returned. You sold 80 SKU112820 and 24 SKU112823 to Race Time. Race Time paid you the full amount into your bank account. You paid $4,235 cash to satisfy warranty claims on faulty products. 29 September 29 September 29 September 29 September 29 September 29 September You sold 40 SKU112822 to Bike Buddies. Bike Buddies paid you the full amount into your bank account. You sold 40 SKU112824 and 28 SKU112820 to Bike Palace. Bike Palace paid you a deposit of 90% of the total sale into your bank account and agreed to pay the remaining 10% on 8th October. You received the full payment from Buzz Bikes for the sales on 21st September, less discount. You received the full payment from Bike Lane for the sales on 27th September, less discount. You are informed that Bike Palace is gone into liquidation and as such you are not able to collect the remaining receivables from Bike Palace. You write off the remaining receivables as bad. You sold the computer that your purchased on 6 September for $4,500 cash incl. GST. Adjusting Journal Entries 30th September This is the final day of the calendar month, and your main task is to prepare the month end accounting entries. For any adjustments required you will need to prepare a general journal entry. The adjusting journals that you will need to enter are as follows - round to TWO decimal places: 1. Interest expense - short-term loan (Northern Bank). (0.25 marks) 2. Insurance expense - product liability insurance policy (Society Insurance). (0.25 marks) 3. First month of subscription revenue earned from the company featured magazine, "RideOn". (0.25 marks) 4. You completed 30% of repairs for Gocycle during September. (0.25 marks) 5. Office supplies on hand at 30th September is $275 incl. GST. (0.25 marks) 6. Depreciation expense - welding machinery, using the units of production method. (0.25 marks) 7. Interest earned at month end. (0.25 marks) 8. Record the adjusting entry for fuel bill payable of $165 incl. GST from Apache Petrol for the final period i.e., period 5. (0.25 marks) 9. Advertising expense amount for the month of September. (0.25 marks) 10. Provision for warranties is equal to 5% of sales. (0.25 marks) 11. You realise that the economy has significantly deteriorated which is observed through the number of customers' debts that are written off during this month. As such you decide to increase the allowance from 10% to 35% of the accounts receivable (as of 30th September 2020). Record the adjusting entry for the allowance for doubtful debts account at 30 September 2020. (0.5 marks) 12. Salaries expense accrued for September. (0.25 marks) 13. Warehouse rent expense accrued for September. (0.25 marks) 14. Depreciation expense Delivery Van, using the straight-line method. (0.25 marks) 15. Depreciation expense Store Building, using the straight-line method. (0.25 marks) 16. Interest expense accrued on the loan for Building of the Head Office. (0.25 marks) 17.40% of deliveries are performed during September. (0.25 marks) 18. Telecommunication accrued for September. (0.25 marks) 19. Insurance expense, Fire insurance. (0.25 marks) Note all month end adjusting journals must be dated 30 September 2020.
Expert Answer:
Related Book For
Managerial Economics and Strategy
ISBN: 978-0321566447
1st edition
Authors: Jeffrey M. Perloff, James A. Brander
Posted Date:
Students also viewed these accounting questions
-
If you buy a new car and try to sell it in the first yearindeed, in the first few weeks after you buy itthe price that you get is substantially less than the original price. Use your knowledge about...
-
On October 1, 2010 Mardy Corporation issued 5%, 10-year bonds with a face value of $1,000,000 at 108 (a 4% yield). Interest is paid on October 1 and April 1, with any premiums or discounts amortized...
-
If you had to create a global code of conduct for your company, what would you include? Which core values would you state?
-
How is the standard form of a circles equation obtained from its general form?
-
Show that Gaussian elimination can be performed on A without row interchanges if and only if all leading principal sub matrices of A are nonsingular. [Hint: Partition each matrix in the equation A...
-
A 1-in. BWG 14 copper condenser tube, 3 m long, is to condense ethyl alcohol at atmospheric pressure. Cooling water inside the tube keeps the metal surface at an essentially constant temperature of...
-
A process for the manufacturer of 4-by-8-foot woodgrained panels has performed in the past with an average of 2.7 imperfections per 100 panels. Construct a chart to be used in the inspection of the...
-
RL Photography reported net income of $100,000 for 2014. Included in the income statement were depreciation expense of $6,300, patent amortization expense of $4,000, and a gain on disposal of plant...
-
Discuss the application of advanced process modeling and simulation tools, such as computational fluid dynamics (CFD), discrete element modeling (DEM), and multiscale modeling, in the design and...
-
The post-closing trial balance for Heron Consulting Services, inc, at December 31 of the prior year is presented here. The company respond the following transactions during the current year: January...
-
What is the output of the C program shown below when the user enters the values 5 and 10 as the program runs? #include int main(void) { } printf ("A B C D "); printf ("RTR Alabama "); int a, b;...
-
These quotes apply to all problems UNLESS stated otherwise. The time period is 1 year for all problems. NOK - Norwegian krona. The quotes are fictitious. Current interest rates are very different....
-
A pole light is mounted 4.8m above a walkway. The light source uniformly emits 8055 Lumens. (a) Calculate the light level on the pathway directly underneath the light fixture (b) Calculate the light...
-
Standard deviation calculations are the following: HT 20%, COLL 11.2%, OM 15.2%, USR 18.8%, and T-Bills 0%. Which of the following has the widest dispersion around the expected return; which is most...
-
what is the situational analysis of The FIBA Women's Basketball World Cup 2022?
-
ypes (s) You are designing a rudimentary pinball machine, and you want your targets to activate whenever the ball pushes the spring back. The target naturally rests at So 1.37 m. Your targets have a...
-
Walt Co. purchases a futures contract specifying FJ$580,500 (FJ$ stands for Fijian dollar, currency of Fiji) with the June settlement date. This futures contract is priced at $0.48/FJ$. On February...
-
(a) What is the focal length of a magnifying glass that gives an angular magnification of 8.0 when the image is at infinity? (b) How far must the object be from the lens?
-
If the inverse demand curve a monopoly faces is p = 10Q0.5, what is the firms marginal revenue curve?
-
In Q& A 14.4, advertising increases the probability of high demand to 80%. If all the other information in the Q& A stays the same, what is the minimum probability of high demand resulting from...
-
At the profit-maximizing quantity in figure, what is the elasticity of demand? What is the Lerner Index?
-
Determine an expansion for the work done in a steady flow adiabatic process.
-
5 m 3 of gas at 8 bar and 180C is heated keeping the pressure same till the volume is doubled. Calculate (a) heat added, (b) external work done, and (c) change in internal energy during the process.
-
A heat engine receives 1000 kW of heat at constant temperature of 285C and rejects heat at 5C . The possible heat rejected are: (a) 840 kW, (b) 442 kW and (c) 300 kW. Comment on the results.
Study smarter with the SolutionInn App