QUESTION 1 Wisliv Ltd was incorporated on the 01/06/16. The opening balance sheet of the company was...

Free

90.2K

Verified Solution

Question

Accounting

QUESTION 1
Wisliv Ltd was incorporated on the 01/06/16. The opening balancesheet of the company was as follows: Cash at bank GHS984000, sharecapital (60,000 ordinary shares of GHS 16.40 each)GHS984,000.
During June the company intends to make payments of GHS 656,000 fora freeholdproperty,           GHS 164,000 for equipment and GHS98,400 for a motor vehicle. Thecompany will also purchase an initial trading stock costingGHS360,800 on credit.
    The company has produced the followingestimates:
i. Sales for June will be GHS131,200 and will increase at the rateof GHS49,200 per month until September. In October, sales will riseto GHS360,800 and this will be maintained for the subsequentmonths.

ii. The gross profit margin on goods sold will be 25%.

iii. There is a risk that supplies of trading stock will beinterrupted towards the end of the accounting year. The company,therefore, intends to build up initial level of stock (GHS 360,800)by purchasing GHS 16,400 of stock each month in addition to themonthly purchases necessary to satisfy monthly sales. All purchasesof stock (including the initial stock will be on one month’scredit).

iv. Sales will be divided equally between cash and credit sales.Credit customers are expected to pay two months after the sale isagreed.

v. Wages and salaries will be GHS 14,760 per month. Other overheadswill be GHS8,200 per month for first four months and GHS 10,660thereafter. Both types of expenses will be payable whenincurred.


vi. 80% of sales will be generated by sales people who will receive5% commission on sales. The commission is payable one month afterthe sale is agreed. The company intends to purchase furtherequipment in November 2016 for GHS 11,480 cash.

vii. Depreciation is to be provided at the rate of 5% per annum onfreehold property and 20% per annum on equipment. (Depreciation hasnot been included in the overheads mentioned above in (v)above.


Required
Prepare a cash budget for Wisliv Ltd. for the six month period to30/11/16.


Question 2
The Sock company buys hiking socks for GHS6 per pair and sells themGHS10. Management budgets monthly fixed costs of GHS12,000 forsales volume between 0 and 12,000 pairs.

Required
Consider the following questions separately by using the foregoinginformation each time.
i. Calculate the breakeven point in units.

ii. The Sock Company reduces its sales price from GHS10 per pair toGHS8 per pair. Calculate the new breakeven point in units.


iii. The Sock Company finds a new supplier for the socks. Variablecosts will decrease by GHS1 per pair. Calculate the breakeven pointin units.

iv. The Sock Company plans to advertise in hiking magazines. Theadvertising campaign will increase total fixed costs by GHS2,000per month. Calculate the new breakeven point in units.

v. In addition to selling hiking socks, the Sock Company would liketo start selling sports socks. The Sock Company expects to sell onepair of hiking socks for every three pairs of sports socks. TheSock Company will buy the sports socks for GHS4 per pair and sellthem for GHS8 per pair. Total fixed costs will stay at GHS12,000per month. Calculate the breakeven point in units for both hikingsocks and sports socks.

Answer & Explanation Solved by verified expert
4.3 Ratings (756 Votes)

Cash Budget for Wisliv Ltd for the six month period to30/11/2016
June July August September October November
Budgeted Sales           131,200           180,400           229,600           278,800           360,800           360,800
Cash sales              65,600              90,200           114,800           139,400           180,400           180,400
Cash collection from credit sales              65,600              90,200           114,800           139,400
Total cash receipts              65,600              90,200           180,400           229,600           295,200           319,800
Cash Outflow
Cash Payment for Inventory                       -             377,200           151,700           188,600           225,500           287,000
Wages and salaries              14,760              14,760              14,760              14,760              14,760              14,760
Other overheads                8,200                8,200                8,200                8,200              10,660              10,660
Sales Commission                5,248                7,216                9,184              11,152              14,432
Cash outflow for operation              22,960           405,408           181,876           220,744           262,072           326,852
Capital expenditure
Freehold property           656,000
Equipment           164,000              11,480
Motor vehicle              98,400
Total capital expenditure           918,400                       -                         -                         -                         -                11,480
Total cash outflow           941,360           405,408           181,876           220,744           262,072           338,332
Net Cash Inflow         (875,760)         (315,208)              (1,476)                8,856              33,128           (18,532)
Beginning Cash Balance           984,000           108,240         (206,968)         (208,444)         (199,588)         (166,460)
Ending Cash Balance           108,240         (206,968)         (208,444)         (199,588)         (166,460)         (184,992)
Inventory Budget
June July August September October November
Budgeted cost of goods sold 98400 135300 172200 209100 270600 270600
Monthly inventory required 135300 172200 209100 270600 270600
Addittional inventory purchase 16400 16400 16400 16400 16400 16400
Initial Trading inventory 360800
Monthly Purchase 377200 151700 188600 225500 287000 287000
Cash payment for inventory 377200 151700 188600 225500 287000

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

QUESTION 1Wisliv Ltd was incorporated on the 01/06/16. The opening balancesheet of the company was as follows: Cash at bank GHS984000, sharecapital (60,000 ordinary shares of GHS 16.40 each)GHS984,000.During June the company intends to make payments of GHS 656,000 fora freeholdproperty,           GHS 164,000 for equipment and GHS98,400 for a motor vehicle. Thecompany will also purchase an initial trading stock costingGHS360,800 on credit.    The company has produced the followingestimates:i. Sales for June will be GHS131,200 and will increase at the rateof GHS49,200 per month until September. In October, sales will riseto GHS360,800 and this will be maintained for the subsequentmonths.ii. The gross profit margin on goods sold will be 25%.iii. There is a risk that supplies of trading stock will beinterrupted towards the end of the accounting year. The company,therefore, intends to build up initial level of stock (GHS 360,800)by purchasing GHS 16,400 of stock each month in addition to themonthly purchases necessary to satisfy monthly sales. All purchasesof stock (including the initial stock will be on one month’scredit).iv. Sales will be divided equally between cash and credit sales.Credit customers are expected to pay two months after the sale isagreed.v. Wages and salaries will be GHS 14,760 per month. Other overheadswill be GHS8,200 per month for first four months and GHS 10,660thereafter. Both types of expenses will be payable whenincurred.vi. 80% of sales will be generated by sales people who will receive5% commission on sales. The commission is payable one month afterthe sale is agreed. The company intends to purchase furtherequipment in November 2016 for GHS 11,480 cash.vii. Depreciation is to be provided at the rate of 5% per annum onfreehold property and 20% per annum on equipment. (Depreciation hasnot been included in the overheads mentioned above in (v)above.RequiredPrepare a cash budget for Wisliv Ltd. for the six month period to30/11/16.Question 2The Sock company buys hiking socks for GHS6 per pair and sells themGHS10. Management budgets monthly fixed costs of GHS12,000 forsales volume between 0 and 12,000 pairs.RequiredConsider the following questions separately by using the foregoinginformation each time.i. Calculate the breakeven point in units.ii. The Sock Company reduces its sales price from GHS10 per pair toGHS8 per pair. Calculate the new breakeven point in units.iii. The Sock Company finds a new supplier for the socks. Variablecosts will decrease by GHS1 per pair. Calculate the breakeven pointin units.iv. The Sock Company plans to advertise in hiking magazines. Theadvertising campaign will increase total fixed costs by GHS2,000per month. Calculate the new breakeven point in units.v. In addition to selling hiking socks, the Sock Company would liketo start selling sports socks. The Sock Company expects to sell onepair of hiking socks for every three pairs of sports socks. TheSock Company will buy the sports socks for GHS4 per pair and sellthem for GHS8 per pair. Total fixed costs will stay at GHS12,000per month. Calculate the breakeven point in units for both hikingsocks and sports socks.

Other questions asked by students