Make a cash budget for the company for July

Assignment Help Accounting Basics
Reference no: EM132820264

Question - XYZ Pty Ltd operates in a seasonal industry with a sales peak in spring. Budgeted sales, along with budgeted raw materials and labour costs are shown in the table below.

Extract from budgeted income statement

Month

Sales

Labour and materials

May

$150,000

$105,000

June

$160,000

$112,000

July

$210,000

$147,000

Aug

$300,000

$210,000

Sep

$400,000

$280,000

Oct

$500,000

$350,000

Nov

$340,000

$238,000

Dec

$200,000

$140,000

All sales are on credit and past records indicate that collections are as follows: 20% in the month of sale, 55% in the month after sale and 25% in the second month after sale. Labour and materials are paid as follows: 60% in the month the expenses are incurred and 40% in the month following that. Other budgeted expenses during the period July to December are as follows: selling, general and administration of $30,000 per month; rent of $10,000 per month; and depreciation of $20,000 per month. Where relevant, payments are made in the month the expenses are incurred.

Taxation payments of $33,000 each will be made at the end of September and end of December. In October, company motor vehicles will be traded-in for new models with an expected net cash payment of $80,000. The motor vehicles are expected to have an 8 year life. The cash balance at 1 July is $10,000.

Required - Make a cash budget for the company for July through to December.

Reference no: EM132820264

Questions Cloud

Calculate the minimum number of jars of silver polish : Calculate the minimum number of jars of silver polish that would have to be sold to justify further processing of Grit 337
How much patent amortization expense would bethany deduct : If Bethany chose to capitalize but not amortize the research and experimental expenses she incurred in year 1, how much patent amortization expense would Bethan
Perspective of the governmental activities : Record this sale (1) from the perspective of the governmental activities at the government-wide level, and (2) from the perspective of the General Fund
How would the cash dividend payments : Additional cash dividends declared during the year amounted to $100,000. How would the cash dividend payments be reported on a Statement of Cash Flows?
Make a cash budget for the company for July : All sales are on credit and past records indicate that collections are as follows: 20% in the month of sale, Make a cash budget for the company for July
What is the total of consolidated revenues : What is the amount of goodwill (while allocating excess) on the date of acquisition and What is the annual amortization/depreciation expense on the excess
Compute the consolidated net income attributable : Compute the Consolidated Net Income Attributable to Controlling Interest and Non-controlling interest respectively using Full-Goodwill
Make a budgeted balance sheet as of september 30 : Make cash budget for the summer and the first semester of college and Make a budgeted balance sheet as of September 30.
Prepare necessary year-end adjusting entries for salaries : Civilizations has incurred and recorded a total salary expense of P875,000. Prepare necessary year-end adjusting entries for salaries

Reviews

Write a Review

Accounting Basics Questions & Answers

  Discuss between exchange and non-exchange transactions

Discuss the four eligibility requirements for revenue recognition in non-exchange transactions,Discuss between exchange and non-exchange transactions

  How do determine the profit margin for trousers using abc

Fleet Street Inc., a manufacturer of high-fashion clothing for women, is located in South London. Determine the profit margin for trousers using ABC

  Prism company is a pesticide manufacturer

Prism Company is a pesticide manufacturer. Its sales declined greatly this year due to the passage of legislation outlawing the sale of several of Prism's chemical pesticides.

  Calculate the cost effectiveness ratio

An intervention has the following cost and benefit profile: Baseline cost = 400,000. Calculate the cost effectiveness ratio

  Find the cost of ending inventory using fifo

Using the perpetual inventory system find the cost of ending inventory using FIFO. data for the inventory transactions completed by the company during the month

  What is x company budgeted contribution margin per unit

X Company expects to produce and sell 60,000 units of its only product next year, and revenue is expected to be $1,885,800. The following are budgeted costs.

  Compute the weighted average method

Weighted Average Method, Unit Cost, Valuing Inventories Lorenen Inc. manufactures products that pass through two or more processes.

  Compute the three ratios after evaluating the effect

Compute the three ratios after evaluating the effect of each transaction that follows. Consider each transaction separately

  What is the amount of refund Cypress can expect

Assuming Cypress is not a personal service corporation, what is the amount of refund Cypress can expect to receive from its 2018 tax return filing

  What is the net amount expected to be collected

What is the net amount expected to be collected of Sheffield Company's accounts receivable after the write-off of the Ramirez receivable

  How do these amounts affect Rachel taxable income

How do these amounts affect Rachel's taxable income? Could there be a related beneficial effect in calculating AMTI? Explain

  Prepare the journal entries necessary to account

Provide the journal entries necessary to account for all the above transactions and events up to 1 July 2023, in accordance with AASB 116 if the revaluation.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd