Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Diamond Company is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months

Diamond Company is preparing a budget for the first quarter of year 2020. The following information is available:

  • Total expected sales for last two months of 2019 and four months of 2020 are (in 000s LE)

    November

    December

    January

    February

    March

    April

    Sales

    200

    200

    160

    160

    180

    150

  • All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month.
  • Cost of goods sold is 70% of sales.
  • The desired ending inventory every month is 30% of the next month's cost of goods sold.
  • It is expected that ending inventory of December, 2019, will be valued at LE 33 600.
  • All purchases are paid in the month of purchases.
  • All cash operating expenses are paid when incurred and the following are the budgeted expenses per month:
  • Wages LE 31 000, Advertising LE 5 000, Depreciation LE 16 000, Rent 12 000.

  • It is planned to pay, for other cash operating expenses, the amount of LE 16 000 in January and LE 43 800 in February 2020.required : prepare cash pudget

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions