Answered step by step
Verified Expert Solution
Link Copied!

Question

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 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

Investment Grade Energy Audit Making Smart Energy Choices

Authors: Shirley J. Hansen, James W. Brown

1st Edition

0824709284, 978-0824709280

Students also viewed these Accounting questions