Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Comp Entries 1 Budget PriestComter Application in Acme Summer 2.2021 PREPARE THE BALANCE SHERE. PROVIT AND LOSS MCCORMICAS FLOW STATEMENT BOOKSTOCK SUMMARY AND BUDGET ANALYSIS

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Comp Entries 1 Budget PriestComter Application in Acme Summer 2.2021 PREPARE THE BALANCE SHERE. PROVIT AND LOSS MCCORMICAS FLOW STATEMENT BOOKSTOCK SUMMARY AND BUDGET ANALYSIS WITH BANK RECONCILIATION Kenya The Music Shop UK POTROX 9577 Addre y Name kurrency Sym Taximal Symbol Tops TUP Per Mobile List of Products Acting Type Laveste Hans KIM WA Meer with ever ad akron. Lola JUISICI 4 7 9 10 11 12 13 14 15 16 Comp Entries 1 Budget ACCOUNTING ENTRIES for The Phone Shop UK 1 "Rachel Halcrow invested 10.750 GBP an "Barclays Bank 2 Lincoln Hakeriested 30,750 GBP 20.750 in HSBC, 10,000 in Barclays 3 Paid 2,575 GBP as fees for Trade License for the year, free EC Rented a building from "Hamptons" for 0,750 GBP for one year 5 Boughts phone Display cabinets for the company for 2,575 GBP cach, from "Wellington Furnitures 6 Paid 50% chance from "Barclays bank for the purchase of the Deplay in Withdrew 1,575 GBP from "Barclays Bank for Cash Counter 8 Purchased "Stativery Hems" for 275 GBP paying Cash Borrowed a bank loan of 30,750 GBP from HSBC payable in 3 yesinterest per year Purchased a "Computer from a department store for : GBP paying casila Purchased the following items from "Nocu 1) 25 Lumia 1320"phones for 475 GBP Cach 2) 40 "Lamia 920 phones for 320 GBP each 3) 35 Lumia 925 phones for 375 GBP each Paid 50% to "Nokia" from "Barclays Bank Purchased the following fiems from Samsung 1) 50"Galaxy Note 7"phones for 450 GBP cach 2) S0"GalaryMaxphones for 250 GBP each 3) 50 Galary S7 phones for 420 GBP each 4) 50 Galary A phones for 320 GBP each Pand 50 GBP for Internet expenses from Cash "Rachel Halcrow withdrew an amount of 2575 GBP for personale HSBC Withdrew cash of 5750 GBP from "Barclays Bank for cash center 12 Sold the following items to "ETA Trading D) IS "Lumia 1320"phomes for 450 GBP each 2) 25 "Lumia 920 phones for GBP each 3) 30 Galary S7 phones for 470 GBP each 4) 30"Galary A9 phones for 365 GRP cach Received full amount from "ETA Trading in Barclays Bank Paid Electricity expenses of 1,750 GBP from SBC 20 2 Galaxy A9 phones were stolen from the store. Amount is expensed under hventory Loss 21 Purchased the following liems from HTC D) 40 HTC One E9 phones for 278 GBP each 2)45 "HTC One M9"phones for 250 GBP each 3) 40 HTC 10 phones for 420 GBP each 4) 40 HTC Butterflyphones for 180 GBP each 22 Sold the following items 10 "EROS Grup 1) 35 HTC One E9 phones for 250 GBP each 2) 30 HTC 10"phones for 480 GBP each 3) 40"Galaxy Note 7 phones for 505 GBP' cach 4) 40"Galary1 Mex"phones for 295 GBP each Received full amount from "EROS Group in Barclays Hank 24 Paid full amount to "Samsung" for the phones purchase from "Barclays Bank 25 Paid Balance 50% to "Nokia" from "Barclays Bank 26 Received a Government Grant of 10.750 GBP for quality and as Cash 27 Deposited 7.575 GBP in HSBC Paid 250 GBP for plumbing repair works from Cash Paid salary for staff, 650 GBP each from HSBC 30 Paid principle and interest for 1 month for the bank loan from HSBC 31 Paid Medical expenses of 250 GBP for Istat from Cash Purchased the following Items from "Apple" 1) 50 "Iphone 6 phones for 550 GBP each 2) 40 "Iphone 5S phones for 515 GRP each 3) 40 Iphone 4S phones for 420 GBP each 4) 25 Iphone 4"phones for 350 GBP each 33 Paid 23. to "Apple" from "Barclays Hank" IR 19 23 28 29 32 1 i 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 2)40 "Iphone 5S phones for 515 GBP each 3) 40 "Iphone 4S phones for 420 GBP each 4) 25 "Iphone 4"phones for 350 GBP each Paid 25% to "Apple" from "Barclays Bank Paid 50% balance payment to "Wellington furnitures" for the purchase of display cabinets from HSBC "EROS Group" returned 2 defective "HTC 10 phones, Sales return Paid "EROS Group" the amount due for the returned photies from Barclays Bank Written off the 2 defective HTC phones as inventory Less" Expense Paid "Miscellaneous Expenses of 150 GBP from Cash Sold the following items from "Electro Inc 1) 35 "Iphone 6S phones for 615 GBP each 2)38 "Iphone 5S phones for 550 GBP each 3) 25"Iphone 4S phones for 460 GBP each 4) 20 "Iphone 4 phones for 390 GBP cach Received 75% of the amount from "Electro Inc" in "HSBC Invested 5150 GBP in Shares belonging to FTSE Company from HSBC Paid the shop rent for 1 month to "Hamptons from "Barclays Bank Received the balance 25% from "Electro Inc" in "Barclays Bank Opened a New Bank account at "Royal Bank of Scotland" und transferred 5.150 GBP from "HSBC Rented a car for 10 days for 15 GBP per day, paid cash Closed "Barclays Bank account and transferred the balance in the bank to "Royal Bank of Scotland" Padanther 25% payable to "Apple" from "Royal Bank of Scotland Booked a depreciation expense of 2,000 GBP Deposited the Balance cash-in-hand in HSEK." Sold the following Items from "Blue Bird 1) 40 HTC One M9" phones for 300 GBP each 2)35 HTC Butterfly phones for 250 GBP each 3) 32 "Lumia 925 phones for 360 GBP each Received full amount from "Blue Bird" in "Royal Bank of Scotland Received 2500 GBP for renting of Office space in HSBC Paid water expenses of 3 GBP from HSBC Sold the following Items to "British Council 1) Is "Iphone 4S phones for 500 GBP each 2) 10 HTC 10 phones for 485 GBP each 3) 18 "Galaxy A9* phones for 375 GBP each 4) 18 "Galaxy S7"phones for 482 GBP each 5)9"Galaxy J Max"phones for 300 GBP each 6) 10 Galaxy Note 7"phomes for 500 GBP each 7) 13 Lumia 920 phones for 350 GBP each Received 75% amount from "British Council" in "Royal Bank of Scotland" Transferred 10000 GBP from "Royal Bank of Scotland to "HSBC Paid an Overdran Expense of 275 GBP from "HSBC Bought a Lexus Car from Lexus Company for 7000 GBP Paid a downpayment of 1000 GBP for the purchase of Lexus Car from "HSBC Paid Salary of 300 GBP each for 3 staff from "Royal Bank of Scotland" Received 3 month Salary of Istallsalary of 300 GBP/month) as compensation for resignation without not Received balance 25 from British Council in HSBC Declared Dividends Payable of 2500 GBP each to "Rachel Halcrow and Lincoln Halcrow Paid another 3 months Advance rent to "Hamptons from "HSBC Booked a depreciation expense of 550 GBP Poid the Dividends payable from "HSBC Received a Dividend of 1000 GBP from the investment in "FTSE Company as Cash Received another Goverment Grant of 15000 GBP in HSBC Paid Radar Fine of 5 GBP from Cash Deposited Balance Cash in Hand in "Royal Bank of Scotland Received a Sponsorship Income of 15000 GBP in "Royal Bank of Scotland Paid tax 15% of "Net Income Before Tax" from "HSBC SI 52 $ 54 55 56 $7 58 59 60 61 62 63 64 65 06 67 68 69 70 71 72 C Comp Entries 1 Budget BUDGET ANALYSIS THE MOBILE SHOT UK Ist Jan 2019 to 31st Dec 2019 Category Actual Variation Variation % Budget Item REVENUE Sale of Phones Dividend Income Government Grant Income From Renting of Office Space Other Income Sponsorship Income EXPENSES Sales Accounts Indirect Income Indirect Income Indirect Income Indirect Income Indirect Income Budgeted 268.300 20027000 1.000 15.000 3.000 1.300 16.000 258.586 Purchase of Phones 204.450 Inventory Loss Expense License Expenses Salary Expenses Depreciation Expenses Electricity Expenses Internet Expenses Water Expenses Medical Expenses Miscellaneous Expenses Printing and Stationery Radar Fines Rent A Car Expenses Rent Expenses Repairs and Maintenance Tax Expenses Interest Expenses Overdrall Expenses NET GAIN LOSS Purchase Accounts Closing Stock Direct Expenses Direct Expenses Direct Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses 1.200 2.500 2.950 2.500 1650 47 90 300 165 280 SO 150 40.000 3:40 1.714 100 200 9.714 1) Draw a graph comparing Actual Gain/Loss with Budgeted Gain Loss 2) Draw a graph comparing Budgeted and Actual values of Revenues and Expenses 3) Draw a graph comparing Budgetod and Actual values of Sales Account Items 4) Draw a graph comparing Budgeted and Actual values of Indirect Income liems 5) Draw a graph comparing Budgeted and Actual values of Purchase Accountiems 6) Draw a graph comparing Budgeted and Actual values of Direct Expenses Items 7) Draw a gruph comparing Budgeted and Actual values of Indirect Expertisies liems 8) Draw a graph indicating the percentage variation for all Revenue heads 9) Draw a graph indicating the percentage variation for all Expenses heads 10) Draw a graph indicating the Actual contributions percentage from all Revenue heads 11) Draw a graph indicating the Actul contributions percentage from all Expenses heads Comp Entries 1 Budget PriestComter Application in Acme Summer 2.2021 PREPARE THE BALANCE SHERE. PROVIT AND LOSS MCCORMICAS FLOW STATEMENT BOOKSTOCK SUMMARY AND BUDGET ANALYSIS WITH BANK RECONCILIATION Kenya The Music Shop UK POTROX 9577 Addre y Name kurrency Sym Taximal Symbol Tops TUP Per Mobile List of Products Acting Type Laveste Hans KIM WA Meer with ever ad akron. Lola JUISICI 4 7 9 10 11 12 13 14 15 16 Comp Entries 1 Budget ACCOUNTING ENTRIES for The Phone Shop UK 1 "Rachel Halcrow invested 10.750 GBP an "Barclays Bank 2 Lincoln Hakeriested 30,750 GBP 20.750 in HSBC, 10,000 in Barclays 3 Paid 2,575 GBP as fees for Trade License for the year, free EC Rented a building from "Hamptons" for 0,750 GBP for one year 5 Boughts phone Display cabinets for the company for 2,575 GBP cach, from "Wellington Furnitures 6 Paid 50% chance from "Barclays bank for the purchase of the Deplay in Withdrew 1,575 GBP from "Barclays Bank for Cash Counter 8 Purchased "Stativery Hems" for 275 GBP paying Cash Borrowed a bank loan of 30,750 GBP from HSBC payable in 3 yesinterest per year Purchased a "Computer from a department store for : GBP paying casila Purchased the following items from "Nocu 1) 25 Lumia 1320"phones for 475 GBP Cach 2) 40 "Lamia 920 phones for 320 GBP each 3) 35 Lumia 925 phones for 375 GBP each Paid 50% to "Nokia" from "Barclays Bank Purchased the following fiems from Samsung 1) 50"Galaxy Note 7"phones for 450 GBP cach 2) S0"GalaryMaxphones for 250 GBP each 3) 50 Galary S7 phones for 420 GBP each 4) 50 Galary A phones for 320 GBP each Pand 50 GBP for Internet expenses from Cash "Rachel Halcrow withdrew an amount of 2575 GBP for personale HSBC Withdrew cash of 5750 GBP from "Barclays Bank for cash center 12 Sold the following items to "ETA Trading D) IS "Lumia 1320"phomes for 450 GBP each 2) 25 "Lumia 920 phones for GBP each 3) 30 Galary S7 phones for 470 GBP each 4) 30"Galary A9 phones for 365 GRP cach Received full amount from "ETA Trading in Barclays Bank Paid Electricity expenses of 1,750 GBP from SBC 20 2 Galaxy A9 phones were stolen from the store. Amount is expensed under hventory Loss 21 Purchased the following liems from HTC D) 40 HTC One E9 phones for 278 GBP each 2)45 "HTC One M9"phones for 250 GBP each 3) 40 HTC 10 phones for 420 GBP each 4) 40 HTC Butterflyphones for 180 GBP each 22 Sold the following items 10 "EROS Grup 1) 35 HTC One E9 phones for 250 GBP each 2) 30 HTC 10"phones for 480 GBP each 3) 40"Galaxy Note 7 phones for 505 GBP' cach 4) 40"Galary1 Mex"phones for 295 GBP each Received full amount from "EROS Group in Barclays Hank 24 Paid full amount to "Samsung" for the phones purchase from "Barclays Bank 25 Paid Balance 50% to "Nokia" from "Barclays Bank 26 Received a Government Grant of 10.750 GBP for quality and as Cash 27 Deposited 7.575 GBP in HSBC Paid 250 GBP for plumbing repair works from Cash Paid salary for staff, 650 GBP each from HSBC 30 Paid principle and interest for 1 month for the bank loan from HSBC 31 Paid Medical expenses of 250 GBP for Istat from Cash Purchased the following Items from "Apple" 1) 50 "Iphone 6 phones for 550 GBP each 2) 40 "Iphone 5S phones for 515 GRP each 3) 40 Iphone 4S phones for 420 GBP each 4) 25 Iphone 4"phones for 350 GBP each 33 Paid 23. to "Apple" from "Barclays Hank" IR 19 23 28 29 32 1 i 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 2)40 "Iphone 5S phones for 515 GBP each 3) 40 "Iphone 4S phones for 420 GBP each 4) 25 "Iphone 4"phones for 350 GBP each Paid 25% to "Apple" from "Barclays Bank Paid 50% balance payment to "Wellington furnitures" for the purchase of display cabinets from HSBC "EROS Group" returned 2 defective "HTC 10 phones, Sales return Paid "EROS Group" the amount due for the returned photies from Barclays Bank Written off the 2 defective HTC phones as inventory Less" Expense Paid "Miscellaneous Expenses of 150 GBP from Cash Sold the following items from "Electro Inc 1) 35 "Iphone 6S phones for 615 GBP each 2)38 "Iphone 5S phones for 550 GBP each 3) 25"Iphone 4S phones for 460 GBP each 4) 20 "Iphone 4 phones for 390 GBP cach Received 75% of the amount from "Electro Inc" in "HSBC Invested 5150 GBP in Shares belonging to FTSE Company from HSBC Paid the shop rent for 1 month to "Hamptons from "Barclays Bank Received the balance 25% from "Electro Inc" in "Barclays Bank Opened a New Bank account at "Royal Bank of Scotland" und transferred 5.150 GBP from "HSBC Rented a car for 10 days for 15 GBP per day, paid cash Closed "Barclays Bank account and transferred the balance in the bank to "Royal Bank of Scotland" Padanther 25% payable to "Apple" from "Royal Bank of Scotland Booked a depreciation expense of 2,000 GBP Deposited the Balance cash-in-hand in HSEK." Sold the following Items from "Blue Bird 1) 40 HTC One M9" phones for 300 GBP each 2)35 HTC Butterfly phones for 250 GBP each 3) 32 "Lumia 925 phones for 360 GBP each Received full amount from "Blue Bird" in "Royal Bank of Scotland Received 2500 GBP for renting of Office space in HSBC Paid water expenses of 3 GBP from HSBC Sold the following Items to "British Council 1) Is "Iphone 4S phones for 500 GBP each 2) 10 HTC 10 phones for 485 GBP each 3) 18 "Galaxy A9* phones for 375 GBP each 4) 18 "Galaxy S7"phones for 482 GBP each 5)9"Galaxy J Max"phones for 300 GBP each 6) 10 Galaxy Note 7"phomes for 500 GBP each 7) 13 Lumia 920 phones for 350 GBP each Received 75% amount from "British Council" in "Royal Bank of Scotland" Transferred 10000 GBP from "Royal Bank of Scotland to "HSBC Paid an Overdran Expense of 275 GBP from "HSBC Bought a Lexus Car from Lexus Company for 7000 GBP Paid a downpayment of 1000 GBP for the purchase of Lexus Car from "HSBC Paid Salary of 300 GBP each for 3 staff from "Royal Bank of Scotland" Received 3 month Salary of Istallsalary of 300 GBP/month) as compensation for resignation without not Received balance 25 from British Council in HSBC Declared Dividends Payable of 2500 GBP each to "Rachel Halcrow and Lincoln Halcrow Paid another 3 months Advance rent to "Hamptons from "HSBC Booked a depreciation expense of 550 GBP Poid the Dividends payable from "HSBC Received a Dividend of 1000 GBP from the investment in "FTSE Company as Cash Received another Goverment Grant of 15000 GBP in HSBC Paid Radar Fine of 5 GBP from Cash Deposited Balance Cash in Hand in "Royal Bank of Scotland Received a Sponsorship Income of 15000 GBP in "Royal Bank of Scotland Paid tax 15% of "Net Income Before Tax" from "HSBC SI 52 $ 54 55 56 $7 58 59 60 61 62 63 64 65 06 67 68 69 70 71 72 C Comp Entries 1 Budget BUDGET ANALYSIS THE MOBILE SHOT UK Ist Jan 2019 to 31st Dec 2019 Category Actual Variation Variation % Budget Item REVENUE Sale of Phones Dividend Income Government Grant Income From Renting of Office Space Other Income Sponsorship Income EXPENSES Sales Accounts Indirect Income Indirect Income Indirect Income Indirect Income Indirect Income Budgeted 268.300 20027000 1.000 15.000 3.000 1.300 16.000 258.586 Purchase of Phones 204.450 Inventory Loss Expense License Expenses Salary Expenses Depreciation Expenses Electricity Expenses Internet Expenses Water Expenses Medical Expenses Miscellaneous Expenses Printing and Stationery Radar Fines Rent A Car Expenses Rent Expenses Repairs and Maintenance Tax Expenses Interest Expenses Overdrall Expenses NET GAIN LOSS Purchase Accounts Closing Stock Direct Expenses Direct Expenses Direct Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses Indirect Expenses 1.200 2.500 2.950 2.500 1650 47 90 300 165 280 SO 150 40.000 3:40 1.714 100 200 9.714 1) Draw a graph comparing Actual Gain/Loss with Budgeted Gain Loss 2) Draw a graph comparing Budgeted and Actual values of Revenues and Expenses 3) Draw a graph comparing Budgetod and Actual values of Sales Account Items 4) Draw a graph comparing Budgeted and Actual values of Indirect Income liems 5) Draw a graph comparing Budgeted and Actual values of Purchase Accountiems 6) Draw a graph comparing Budgeted and Actual values of Direct Expenses Items 7) Draw a gruph comparing Budgeted and Actual values of Indirect Expertisies liems 8) Draw a graph indicating the percentage variation for all Revenue heads 9) Draw a graph indicating the percentage variation for all Expenses heads 10) Draw a graph indicating the Actual contributions percentage from all Revenue heads 11) Draw a graph indicating the Actul contributions percentage from all Expenses heads

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Theory Contemporary Accounting Issues

Authors: Thomas G. Evans

1st Edition

0324107846, 9780324107845

Students also viewed these Accounting questions