Cash Accounts receivable Inventory Equipment Less: Accumulated depreciation Total assets Liabilities and Equity Liabilities Accounts payable...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cash Accounts receivable Inventory Equipment Less: Accumulated depreciation Total assets Liabilities and Equity Liabilities Accounts payable Coan payable Taxes payable (due March 15) Equity Common stock Retained earnings Total liabilities and equity $636,000 79,500 $365,000 14,000 91,000 $ 471,000 298,500 $ 20,500 520,000 142,500 556,500 $1,239,500 470,000 769,500 $1,239,580 To prepare a master budget for January, February, and March, use the following information. a. The company's single product is purchased for $30 per unit and resold for $59 per unit. The inventory level of 4,750 units on December 31 is more than management's desired level, which is 20% of the next month's budgeted sales units. Budgeted sales are January,6,750 units; February, 8,750 units; March, 11,000 units; and April, 11,000 units. All sales are on credit. b. Cash receipts from sales are budgeted as follows: January, $259,388; February, $728.239; March, $529,731 c. Cash payments for merchandise purchases are budgeted as follows: January $65,000; February, $322,500; March, $145,200. d. Sales commissions equal to 20% of sales dollars are paid each month. Sales salaries (excluding commissions) are $7,000 per month. e. General and administrative salaries are $12,000 per month. Maintenance expense equals $1,800 per month and is paid in cash. t New equipment purchases are budgeted as follows: January, $40,800, February $103,200, and March, $26,400. Budgeted depreciation expense is January: $ 7050, February, $8.125; and March, $8,400. 9. The company budgets a land purchase at the end of March at a cost of $170,000, which will be paid with cash on the last day of the month. h. The company has an agreement with its bank to obtain additional loans as needed. The interest rate is 1% per month and interest is paid at each month-end based on the beginning-month balance Partial or full payments on these loans are made on the last day of the month. The company maintains a minimum ending cash belance of $20,500 at the end of each month. L. The income tax rate for the company is 43%. Income taxes on the first quarter's income will not be paid until April 15. Required: Prepare a master budget for the months of January, February, and Merch that has the following budgets: 1. Sales budget. 2. Merchandise purchases budgets. 3. Selling expense budgets. 4. General and administrative expense budgets Hint Depreciation is included in the general and administrative budget for merchandisers 5. Capital expenditures budgets 6. Cash budgets 7. Budgeted income statement for entire quarter (not monthly) ended March 31 8. Budgeted balance sheet as of March 31 Cash Accounts receivable Inventory Equipment Less: Accumulated depreciation Total assets Liabilities and Equity Liabilities Accounts payable Coan payable Taxes payable (due March 15) Equity Common stock Retained earnings Total liabilities and equity $636,000 79,500 $365,000 14,000 91,000 $ 471,000 298,500 $ 20,500 520,000 142,500 556,500 $1,239,500 470,000 769,500 $1,239,580 To prepare a master budget for January, February, and March, use the following information. a. The company's single product is purchased for $30 per unit and resold for $59 per unit. The inventory level of 4,750 units on December 31 is more than management's desired level, which is 20% of the next month's budgeted sales units. Budgeted sales are January,6,750 units; February, 8,750 units; March, 11,000 units; and April, 11,000 units. All sales are on credit. b. Cash receipts from sales are budgeted as follows: January, $259,388; February, $728.239; March, $529,731 c. Cash payments for merchandise purchases are budgeted as follows: January $65,000; February, $322,500; March, $145,200. d. Sales commissions equal to 20% of sales dollars are paid each month. Sales salaries (excluding commissions) are $7,000 per month. e. General and administrative salaries are $12,000 per month. Maintenance expense equals $1,800 per month and is paid in cash. t New equipment purchases are budgeted as follows: January, $40,800, February $103,200, and March, $26,400. Budgeted depreciation expense is January: $ 7050, February, $8.125; and March, $8,400. 9. The company budgets a land purchase at the end of March at a cost of $170,000, which will be paid with cash on the last day of the month. h. The company has an agreement with its bank to obtain additional loans as needed. The interest rate is 1% per month and interest is paid at each month-end based on the beginning-month balance Partial or full payments on these loans are made on the last day of the month. The company maintains a minimum ending cash belance of $20,500 at the end of each month. L. The income tax rate for the company is 43%. Income taxes on the first quarter's income will not be paid until April 15. Required: Prepare a master budget for the months of January, February, and Merch that has the following budgets: 1. Sales budget. 2. Merchandise purchases budgets. 3. Selling expense budgets. 4. General and administrative expense budgets Hint Depreciation is included in the general and administrative budget for merchandisers 5. Capital expenditures budgets 6. Cash budgets 7. Budgeted income statement for entire quarter (not monthly) ended March 31 8. Budgeted balance sheet as of March 31
Expert Answer:
Answer rating: 100% (QA)
To prepare a master budget for January February and March we will create the following budgets 1 Sales Budget January 6750 units 59 398250 February 8750 units 59 516250 March 11000 units 59 649000 2 M... View the full answer
Related Book For
College Accounting Chapters 1-30
ISBN: 978-1259631115
15th edition
Authors: John Price, M. David Haddock, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
With seven principles of The Talent Masters, how would you define the Continuous learning and improvement in the company based on how a company could implement it?
-
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company...
-
Given that the notion of HRM is seen in some countries to be more advanced than the idea of personnel management, why might the latter continue to be the preferred terminology in most of Europe?
-
In order to hedge its Mexican peso earnings, All-American is considering borrowing mxn 25 million, but is concerned about losing its usd interest tax shield. The exchange rate is usd/mxn 0.4, rt,T =...
-
The following relates to one share of XYZ stock: The current price is 100. The forward price for delivery in one year is 105. P is the expected price in one year. Determine which of the following...
-
In Example 8.4, choose methane and hydrogen as independent components. Derive relationships for the remaining components in terms of methane and hydrogen. Data From Example 8.4:- Construct the...
-
The stockholders equity section of Jarvis Corporation at December 31 is as follows Instructions From a review of the stockholders equity section, as chief accountant, write a memo to the president of...
-
A firm's stock sells for $25.00 and they recently declared a dividend of $1.25 per share. Their long term growth rate is 2.5%. What is the stock's expected dividend yield for the Not yet coming year?
-
On January 1, 2020, Trigson Ltd. had 580,000 common shares outstanding. During 2020, it had the following transactions that affected the common share account: Feb. 1 Issued 180,000 shares. Mar. 1...
-
Conrad operates an online website support service. Conrad does not meet his clients in his home. Conrad purchased the following items for his qualified home office. All the items are deductible or...
-
During 2026, Colorado Co. stock was sold for $9,650. The fair value of the stock on December 31, 2026, was Clemson Corp. stock- $21,010; Buffaloes Co. stock-$22,380. None of the equity investments...
-
lim h0 Suppose f(x)=-3x + 4. Evaluate the following limit. f(-4+ h)-f(-4) h = Note: Input DNE, infinity, -infinity for does not exist, , and -, respectively.
-
15. Nichrome wire of cross-sectional radius 0.791 mm is to be used in winding a heating coil. If the coil must carry a current of 9.25 A when a voltage of 1.20 x 10 V is applied across its ends, find...
-
Suppose you purchased 9 5 shares of ABC, Inc for $ 4 0 . 9 9 per share. The company paid a dividend of $ 1 . 3 per share during the year, and had an ending share price of $ 7 4 . 1 2 . What is the...
-
Refer to the eight weeks of actual data included in the Excel template. a . Use least - squares regression to estimate the fixed electrical cost per week and the variable electrical cost per machine...
-
Jobs, Inc. has recently started the manufacture of Tri-Robo, a three-wheeled robot that can scan a home for fires and gas leaks and then transmit this information to a smartphone. The cost structure...
-
Find the volume of the described solid S. A frustum of a right circular cone with height h, lower base radius R, and top radius r -r- --R
-
Daily Corporation has outstanding 85,000 shares of $30 par-value preferred stock, issued at an average price of $37 a share. The preferred stock is convertible into common stock at the rate of three...
-
Nelson Ellis and Hank Tollis are partners who share profits and losses in the ratio of 40 to 60 percent, respectively. The balances of their capital accounts on December 31, 2018, are Ellis,...
-
What is open-account credit?
-
Natural gas (methane) flows from a 3-in.-diameter gas main, through a 1-in.-diameter pipe, and into the burner of a furnace at a rate of \(100 \mathrm{ft}^{3} /\) hour. Determine the pressure in the...
-
SAE 30 oil at \(60^{\circ} \mathrm{F}\) flows through a 2-in.-diameter pipe with a mean velocity of \(5 \mathrm{ft} / \mathrm{s}\). Determine the value of the Reynolds number (see Example 1.4)....
-
Calculate the Reynolds numbers for the flow of water and for air through a 4-mm-diameter tube, if the mean velocity is \(3 \mathrm{~m} / \mathrm{s}\) and the temperature is \(30^{\circ} \mathrm{C}\)...
Study smarter with the SolutionInn App