Y Co's fiscal year begins on April 1. The following is an extract from a trial...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Y Co's fiscal year begins on April 1. The following is an extract from a trial balance at May 31, 2020: DR CR Cash Accounts Receivable $54,400 Bad Debt Allowance Inventory Merchandise $32,000 Accounts Payable Merchandise$14,000 $7,000 $4.480 Data concerning company's purchase of merchandise inventory: Purchase price per unit $16 75% of any month's purchases ae payable in the month of purchase while the rest is due and paid for in the following month. At end of each month the company's policy is to have an inventory equal to 50% of the following month's unit sales. Sales Data: Selling price per unit April actual sales revenue May actual sales revenue June estimated sales $32 $64,000 $96,000 revenue $128,000 July estimated sales $112,000 $1,600,000 revenue Total sales expected in fiscal year 50% of billings are collected during the month of sale, 40% in the following month, 7% in the next following calendar month and 3% is uncollectable. Customers are allowed a 2% cash discount if payment is made by the end of the calendar month in which the sales took place. Selling and administrative expenses (exclusive of bad debt expenses): Total selling and admin expenses for fiscal year Total fixed selling & admin expenses for fiscal year (included in total) incurred evenly throughout the year $216,000 $48,000 Annual amortization expense (included in fixed selling and admin expense) $12,000 I Variable selling and administrative expenses vary with sales revenue. Selling and administrative expenses are paid as incurred. Required: a) Prepare a cash budget for Y Co for June 2020. b) What are the components of a master budget? Y Co's fiscal year begins on April 1. The following is an extract from a trial balance at May 31, 2020: DR CR Cash Accounts Receivable $54,400 Bad Debt Allowance Inventory Merchandise $32,000 Accounts Payable Merchandise$14,000 $7,000 $4.480 Data concerning company's purchase of merchandise inventory: Purchase price per unit $16 75% of any month's purchases ae payable in the month of purchase while the rest is due and paid for in the following month. At end of each month the company's policy is to have an inventory equal to 50% of the following month's unit sales. Sales Data: Selling price per unit April actual sales revenue May actual sales revenue June estimated sales $32 $64,000 $96,000 revenue $128,000 July estimated sales $112,000 $1,600,000 revenue Total sales expected in fiscal year 50% of billings are collected during the month of sale, 40% in the following month, 7% in the next following calendar month and 3% is uncollectable. Customers are allowed a 2% cash discount if payment is made by the end of the calendar month in which the sales took place. Selling and administrative expenses (exclusive of bad debt expenses): Total selling and admin expenses for fiscal year Total fixed selling & admin expenses for fiscal year (included in total) incurred evenly throughout the year $216,000 $48,000 Annual amortization expense (included in fixed selling and admin expense) $12,000 I Variable selling and administrative expenses vary with sales revenue. Selling and administrative expenses are paid as incurred. Required: a) Prepare a cash budget for Y Co for June 2020. b) What are the components of a master budget?
Expert Answer:
Related Book For
Financial Accounting and Reporting
ISBN: 978-0273744443
14th Edition
Authors: Barry Elliott, Jamie Elliott
Posted Date:
Students also viewed these accounting questions
-
The following is an extract from Accountancy Age, 25 January 2001. A powerful and shadowy group of senior partners from the seven largest firms has emerged to move closer to edging control of...
-
The following is an extract from the property, plant and equipment section of a balance sheet. The objective of financial statements is to provide information that is useful for decision making. As a...
-
The following is an extract from the trial balance of Imecet at 31 October 2005: .:. Other relevant information: (i) One million $1 Ordinary shares were issued 1 May 2005 at the market price of...
-
Write a nonrecursive function that takes the first Node in a linked list as an argument and reverses the list, returning the first Node in the result.
-
Assume that the aggregate demand curve shifts to the right through increased government spending. Assuming that the position of the AD curve changes, how does this event affect the government budget...
-
Cameron Diaz promotes environmental causes if Ben Affleck supports civil liberties, provided that Sean Penn opposes the death penalty. Translate the following statements into symbolic form using...
-
Assume you had to serve a complaint on a defendant in Los Angeles, California. Find a company that would be available for service of process.
-
Toms Tax Services is a small accounting firm that offers tax services to small businesses and individuals. One of Toms major clients, the Orange Café, is considering moving its business...
-
Use the information provided in Table 6 to calculate the cost to issue a life insurance policy, including receiving and processing applications for each product. An activity-based costing system...
-
I'm not sure which table I need to use, FVAD or FVA or... On September 30, 2021, Ferguson Imports leased a warehouse. Terms of the lease require Ferguson to make 15 annual lease payments of $52,000...
-
Bifurcations of the dynamical systems listed below are controlled by parameter u. For each case examine and discuss its dynamic stability. Specifically, name the type of bifurcation, determine fixed...
-
What is segmentation? What benefits do marketers gain from segmentation analyses?
-
What targeting approaches can marketers choose?
-
The study recorded whether participants were female or male \((S e x=F\) or M), and we see that 33 of the 165 females and 42 of the 99 males allowed the pressure to reach its maximum level of \(300...
-
A conveyor belt conveys finished products to the warehouse at an average of 2 per minute. Find the probabilities that (a) at most 3 will be conveyed in a given minute; (b) at least 2 will be conveyed...
-
What is marketing strategic planning?
-
explaining how having an incarcerated parents has affected you, your parents, and other members of your family
-
Chicago Company sold merchandise to a customer for $1,500 cash in a state with a 6% sales tax rate. The total amount of cash collected from the customer was $558. $600. $642. $636. Nevada Company...
-
Delta Ltd has been developing a lightweight automated wheelchair. The research costs written off have been far greater than originally estimated and the equity and preference capital has been eroded...
-
Olive A/S, incorporated with an authorised capital consisting of one million ordinary shares of ¬1 each, employs 646 persons, of whom 428 work at the factor y and the rest at the head office. The...
-
Epsilon is a listed entity. You are the financial controller of the entity and its consolidated financial statements for the year ended 30 September 2008 are being prepared. Your assistant, who has...
-
Assume that an account has the following characteristics: Number of items in the account-300 Recorded amount- \(\$ 600,000\) Sample size-100 Required: a. If the sample mean is \(\$ 1,800\) and mean...
-
You desire to estimate the amount of the inventory of your client. Draper. Inc. You satisfied yourself earlier as to the inventory quantities. During the audit of the pricing and extension of the...
-
The following data for a substantive test using sampling are available: Population recorded amount- \(\$ 200,000\) Tolerable misstatement \(\$ 10,000\) Number of items in the population-200 Risk of...
Study smarter with the SolutionInn App