a. As of December 31 (the end of the prior quarter), the company's general ledger showed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Common stock Retained earnings Debits Credits $ 50,000 208,000 59,250 360,000 $ 88,125 500,000 89,125 $ 677,250 $ 677,250 b. Actual sales for December and budgeted sales for the next four months are as follows: December (actual) January February March April $ 260,000 $ 395,000 $ 592,000 $ 306,000 $ 203,000 c. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. d. The company's gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.) e. Monthly expenses are budgeted as follows: salaries and wages, $25,000 per month; advertising, $65,000 per month; shipping, 5% of sales; other expenses, 3% of sales. Depreciation, Including depreciation on new assets acquired during the quarter, will be $43,700 for the quarter. f Each month's ending Inventory should equal 25% of the following month's cost of goods sold. g. One-half of a month's Inventory purchases is paid for in the month of purchase; the other half is paid in the following month. h. During February, the company will purchase a new copy machine for $2,000 cash. During March, other equipment will be purchased for cash at a cost of $75,000. 1. During January, the company will declare and pay $45,000 in cash dividends. J. Management wants to maintain a minimum cash balance of $30,000. The company has an agreement with a local bank allowing it to borrow in Increments of $1,000 at the beginning of each month. The interest rate on these loans Is 1% per month, and for simplicity, we will assume interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated Interest at the end of the quarter. Required: Using the data above, complete the following statements and schedules for the first quarter: 1. Schedule of expected cash collections: 2-a. Merchandise purchases budget 2-b. Schedule of expected cash disbursements for merchandise purchases 3. Cash budget 4. Prepare an absorption costing Income statement for the quarter ending March 31 5. Prepare a balance sheet as of March 31, 13 a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Common stock Retained earnings Debits Credits $ 50,000 208,000 59,250 360,000 $ 88,125 500,000 89,125 $ 677,250 $ 677,250 b. Actual sales for December and budgeted sales for the next four months are as follows: December (actual) January February March April $ 260,000 $ 395,000 $ 592,000 $ 306,000 $ 203,000 c. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. d. The company's gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.) e. Monthly expenses are budgeted as follows: salaries and wages, $25,000 per month; advertising, $65,000 per month; shipping, 5% of sales; other expenses, 3% of sales. Depreciation, Including depreciation on new assets acquired during the quarter, will be $43,700 for the quarter. f Each month's ending Inventory should equal 25% of the following month's cost of goods sold. g. One-half of a month's Inventory purchases is paid for in the month of purchase; the other half is paid in the following month. h. During February, the company will purchase a new copy machine for $2,000 cash. During March, other equipment will be purchased for cash at a cost of $75,000. 1. During January, the company will declare and pay $45,000 in cash dividends. J. Management wants to maintain a minimum cash balance of $30,000. The company has an agreement with a local bank allowing it to borrow in Increments of $1,000 at the beginning of each month. The interest rate on these loans Is 1% per month, and for simplicity, we will assume interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated Interest at the end of the quarter. Required: Using the data above, complete the following statements and schedules for the first quarter: 1. Schedule of expected cash collections: 2-a. Merchandise purchases budget 2-b. Schedule of expected cash disbursements for merchandise purchases 3. Cash budget 4. Prepare an absorption costing Income statement for the quarter ending March 31 5. Prepare a balance sheet as of March 31, 13
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
3. Calculate the work done, W=mgh for a mass of 300 g. Then, using the accepted value for the specific heat of water, calculate the change in heat, Q=cmAT for the same data point. a) Calculate the...
-
Your buddy mentioned that she is thinking about suing under the qui tam law. You are not sure what that is. a. What is a qui tam provision? b. Can employees who do not work for the government sue...
-
Suppose that x0 > 2 and xn = 2 + xn-1 - 2 for n N. Use the Monotone Convergence theorem to prove that either xn 2 or xn 3 as n .
-
For the following exercises, write an equation describing the relationship of the given variables. y varies jointly as the square of x and the square of z and when x = 3 and z = 4, then y = 72.
-
In a randomly selected sample of women ages 20 34, the mean total cholesterol level is 179 milligrams per deciliter with a standard deviation of 38.9 milligrams per deciliter. Assume the total...
-
Gillian Shaw opened Shaws Carpet Cleaners on March 1. During March, the following transactions were completed. Mar. 1 Invested $10,000 cash in the business. 1 Purchased used truck for $6,000, paying...
-
In Thunder Bay, a public survey was done that suggests that people are generally supportive of using automated, AI-based video analysis software [1]. Yet, elsewhere in Canada, such software has come...
-
I found the source which is related to my recent task, but it is not full essay. Find the full version of this essay? Callaway real estate limited partnership from: Chia Blais re: 2010 taxable income...
-
One form of whispering gallery is an elliptical room where a person standing at one focus can hear quite clearly someone speaking very quietly at the other focus. Use your knowledge of ellipses to...
-
The volume flow rate of water at \(20.0^{\circ} \mathrm{C}\) through a cylindrical pipe is \(2.00 \times 10^{-4} \mathrm{~m}^{3} / \mathrm{s}\). What is the volume flow rate of castor oil moving...
-
A \(0.100-\mathrm{kg}\) ball attached to a \(0.20-\mathrm{m}\) rod of very small inertia moves in a vertical circle in such a way that its speed remains constant. Let \(\mathcal{T}_{1},...
-
A cannon is fired some distance away from you, and you wish to estimate that distance by determining how much sound energy enters your ear. (a) How does the sound energy depend on the distance...
-
You insert a pipette of diameter \(0.700 \mathrm{~mm}\) into a liquid that is at \(20.0^{\circ} \mathrm{C}\) and has a mass density of \(1261 \mathrm{~kg} / \mathrm{m}^{3}\). If the liquid rises...
-
The spot price of an investment asset is $30 and the risk-free rate for all maturities is 10% with continuous compounding. The asset provides an income of $2 at the end of the first year and at the...
-
Use translations to graph f. f(x) = x-/2 +1
-
(a) Find the Laplace transform of \(f(t)=50\left[e^{-100 t}-2 e ight.\) \(-200 t] u(t)\). (b) Locate the poles and zeros of \(F(s)\). (c) What is the time constant associated with each pole? (d)...
-
Find the Laplace transform of \(f(t)=\delta^{\prime}(t)+\delta(t)-e^{-t} u\) \((t)\). Locate the poles and zeros of \(F(s)\).
-
Find the Laplace transform of \(f(t)=A\left[(B+\alpha t) e^{-\alpha t} ight.\) ]\(u(t)\). Locate the poles and zeros of \(F(s)\).
Study smarter with the SolutionInn App