The Peoria Supply Company sells for $40 one product that it purchases for $30. Budgeted sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Peoria Supply Company sells for $40 one product that it purchases for $30. Budgeted sales in total dollars for next year are $720,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $30,000 June 41,000 July 50,000 August 51,000 Account balances at July 1 include these: Cash $20,000 Merchandise inventory 14,000 Accounts receivable (sales) 23,000 Accounts payable (purchases) 14,000 The company pays for one-half of its purchases in the month of purchase and the remainder in the following month. End-of-month inventory must be 50 percent of the budgeted sales in units for the next month. A 2 percent cash discount on sales is allowed if payment is made during the month of sale. Experience indicates that 50 percent of the billings will be collected during the month of sale, 40 percent in the following month, 6 percent in the second following month, and 4 percent will be uncollectible. Total budgeted selling and administrative expenses (excluding bad debts) for the fiscal year are estimated at $174,000, of which one-half is fixed expense (inclusive of a $20,000 annual depreciation charge). Fixed expenses are incurred evenly during the year. The other selling and administrative expenses vary with sales. Expenses are paid during the month incurred. (Round your answers to the nearest whole number.) Part A Part B Part C Part D (d) Prepare a cash budget in summary form for July. Only use a negative sign with your answer for Excess receipts (disbursements) to indicate if the answer is Excess disbursements. Otherwise, do not use negative signs with any answers below. Peoria Supply Company Cash Budget For the Month of July Cash receipts $ 0% Cash disbursements: Merchandise Selling and administrative Excess receipts (disbursements) $ 0% 0% $ 0% A X The Peoria Supply Company sells for $40 one product that it purchases for $30. Budgeted sales in total dollars for next year are $720,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $30,000 June 41,000 July 50,000 August 51,000 Account balances at July 1 include these: Cash $20,000 Merchandise inventory 14,000 Accounts receivable (sales) 23,000 Accounts payable (purchases) 14,000 The company pays for one-half of its purchases in the month of purchase and the remainder in the following month. End-of-month inventory must be 50 percent of the budgeted sales in units for the next month. A 2 percent cash discount on sales is allowed if payment is made during the month of sale. Experience indicates that 50 percent of the billings will be collected during the month of sale, 40 percent in the following month, 6 percent in the second following month, and 4 percent will be uncollectible. Total budgeted selling and administrative expenses (excluding bad debts) for the fiscal year are estimated at $174,000, of which one-half is fixed expense (inclusive of a $20,000 annual depreciation charge). Fixed expenses are incurred evenly during the year. The other selling and administrative expenses vary with sales. Expenses are paid during the month incurred. (Round your answers to the nearest whole number.) Part A Part B Part C Part D (d) Prepare a cash budget in summary form for July. Only use a negative sign with your answer for Excess receipts (disbursements) to indicate if the answer is Excess disbursements. Otherwise, do not use negative signs with any answers below. Peoria Supply Company Cash Budget For the Month of July Cash receipts $ 0% Cash disbursements: Merchandise Selling and administrative Excess receipts (disbursements) $ 0% 0% $ 0% A X
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Governmental accounting gives substantial recognition to budgets, with budgets being recorded in the accounts of the governmental unit. What is meant by budgetary accounting ? What is the purpose of...
-
Write short notes on: (i) Fundamental accounting assumptions. (ii) Periodicity concept. (iii) Accounting conventions.
-
Cash Budget The Peoria Supply Company sells for $30 one product that it purchases for $20. Budgeted sales in total dollars for next year are $720,000. The sales information needed for preparing the...
-
Ha: μ1 > μ2 The null hypothesis is H0: μ1 = μ2 and the alternative hypothesis is as specified. We have provided data from a simple random...
-
a. If the dealer network was indeed a relic from five decades ago, why wait until now to fix it? b. What is meant by the statement that the car business is now a commodity business? c. How will these...
-
On January 1, Chevon Enterprises SA had 98,000 no-par ordinary shares issued and outstanding. The shares have a stated value of 4 per share. During the year, the following occurred. Apr. 1 Issued...
-
As the management accountant, the manager has asked you to explain the merits of the following capital investment appraisal techniques and make recommendations for a capital investment process to be...
-
At the time of Matthews death, he was involved in the transactions described below. Matthew was a participant in his employers contributory qualified pension plan. The plan balance of $2 million is...
-
Find the domain of f (x) = 4 I. (4,) O (-0,4] (-0,4) [4,) (-0.4) (4.00) (-x,x)
-
Prepare the adjusting journal entries in the worksheet labelled ABC. The adjusted trial balance columns will update automatically. You need to enter the journal entry reference letters(a,b,c,etc.) In...
-
Question 12 (1 points) An electron travels through a particular point in an experimental apparatus with a velocity of 0.867 106 m/s and at an angle of +54.7 (counter- clockwise) relative to the...
-
Tye-Dye Company acquired machinery on Sept 1, 2023, for $1,410,000. The machinery's estimated useful life is 5 years, and the estimated residual value is $124,000. The company estimates that the...
-
What are the main building modules of the Entity Relationship model? Discuss each one.
-
Oriole Company is considering a long-term investment project called ZIP. ZIP will require an investment of $128,000. It will have a useful life of 4 years and no salvage value. Annual cash inflows...
-
(a) Prepare journal entries to record each of the following: (i) The opening entries of T. Lee who commenced his business on 1 April 2007. Premises Office equipment Stock Bank Cash $ 60,000 5,000...
-
You are a junior researcher in a small investment fund. Your boss asks you to write a quick overview of Modern covid vaccination that will be used to decide whether to do more in-depth research as a...
-
Assume a stock price of $42; a risk-free rate of 3.5 percent per year, compounded continuously; a six-month maturity; and a standard deviation of 64 percent per year. If a six-month call with an...
-
A glass manufacturer produces hand mirrors. Each mirror is supposed to meet company standards for such things as glass thickness, ability to reflect, size of handle, quality of glass, color of...
-
Reida Oil Corporation incurred the following costs during the fiscal year ending May 31, 2015. Prepare journal entries for the above transaction, assuming that Reida Oil Corporation uses the full...
-
Revenue and costs for Optimistic Company for the year 2015 are presented below: Prepare income statements and unclassified balance sheets for a successful efforts (SE) company and a full cost (FC)...
-
Elizabeth Corporation incurred the following costs during 2015: Elizabeth uses the successful efforts method of accounting. Prepare the journal entries for the year-end December 31, 2015. January 12...
Study smarter with the SolutionInn App