1. Sales forecast January: 5,100 units; February: 6,900 units, March: 7,300 units; April: 7,500 umits. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Sales forecast January: 5,100 units; February: 6,900 units, March: 7,300 units; April: 7,500 umits. The unit sales price is $55. All sales are on credit and collections are 30% in the month of sale and 70% the following month. Accoumts receivable as of December 31 of the previous year was $18,000; this amount is expected to be collected in January of the current year. 2. End of month inventory must equal 30% of next month's sales. The inventory at the end of December 31 of the previous year was 1,530 umits. 3. The following are the expected costs for direct materials, direct labor and manufacturing overbead: DL $15/unit DM $12/unit Overhead $7,500 + $2.65 per unit produced Jamuary February $12/unit $15/unit $7,500 + $2.65 per unit produced $7,500 + $2.65 per unit produced March $12/unit $15/unit A. Direct materials are paid 40% in the month incurred and 60% in the following month. Account payable for materials as of December 31 is $5,100, this amount will be paid in January. B. Direct labor is paid in the month incurred C. Overbead costs are paid in the month incurred Fixed overhead includes depreciation of $5,500 per month. 4. Selling costs are sales commissions: $2.10 per unit sold; shipping costs: $0.50 per unit sold. Administrative costs per month are: salaries: $15,000; rent. $2,000, depreciation: $1,900. All costs are paid in month incurred. 5. The company plans to buy equiprment costing $100,000 in February and to pay dividends of $40,000 in March 6. The cash balance as of December 31 of the previous year was $25,000. The company requires a minimum cash balance of $5,000. The company has a revolving credit with US Bank to borrow in increments of $1,000 at the beginning of each month at interest of 12% annual rate. The company may borrow at the beginning of any month and repays its loans, or any parts of its loans, at the end of any month. Interest payments are due on any principle at the time it is repaid (the amount repaid does not have to be in increments of $1.000). For simplicity, assume that interest is not compounded. As of December 31 the company has no outstanding loans. Required: Based on the infomation given, prepare the following budgets for each month of the first quarter of 2021 and the quarter totals: 1. Sales Budget, including a schedule of expected cash collections; 2. Production Budget (in units); 3. Direct materials budget, including schedule of expected cash disbursements; 4. Direct labor budget, 5. Manufacturing Overhead Budget; 6. Selling and Administrative Expenses Budget; 7. Cash Budget. 1. Sales forecast January: 5,100 units; February: 6,900 units, March: 7,300 units; April: 7,500 umits. The unit sales price is $55. All sales are on credit and collections are 30% in the month of sale and 70% the following month. Accoumts receivable as of December 31 of the previous year was $18,000; this amount is expected to be collected in January of the current year. 2. End of month inventory must equal 30% of next month's sales. The inventory at the end of December 31 of the previous year was 1,530 umits. 3. The following are the expected costs for direct materials, direct labor and manufacturing overbead: DL $15/unit DM $12/unit Overhead $7,500 + $2.65 per unit produced Jamuary February $12/unit $15/unit $7,500 + $2.65 per unit produced $7,500 + $2.65 per unit produced March $12/unit $15/unit A. Direct materials are paid 40% in the month incurred and 60% in the following month. Account payable for materials as of December 31 is $5,100, this amount will be paid in January. B. Direct labor is paid in the month incurred C. Overbead costs are paid in the month incurred Fixed overhead includes depreciation of $5,500 per month. 4. Selling costs are sales commissions: $2.10 per unit sold; shipping costs: $0.50 per unit sold. Administrative costs per month are: salaries: $15,000; rent. $2,000, depreciation: $1,900. All costs are paid in month incurred. 5. The company plans to buy equiprment costing $100,000 in February and to pay dividends of $40,000 in March 6. The cash balance as of December 31 of the previous year was $25,000. The company requires a minimum cash balance of $5,000. The company has a revolving credit with US Bank to borrow in increments of $1,000 at the beginning of each month at interest of 12% annual rate. The company may borrow at the beginning of any month and repays its loans, or any parts of its loans, at the end of any month. Interest payments are due on any principle at the time it is repaid (the amount repaid does not have to be in increments of $1.000). For simplicity, assume that interest is not compounded. As of December 31 the company has no outstanding loans. Required: Based on the infomation given, prepare the following budgets for each month of the first quarter of 2021 and the quarter totals: 1. Sales Budget, including a schedule of expected cash collections; 2. Production Budget (in units); 3. Direct materials budget, including schedule of expected cash disbursements; 4. Direct labor budget, 5. Manufacturing Overhead Budget; 6. Selling and Administrative Expenses Budget; 7. Cash Budget.
Expert Answer:
Answer rating: 100% (QA)
sOLUTION Company Inc Sales Budget For the Quarter Ended xxxxxx Months Particulars Jan Feb Mar April Quarter Budgeted Unit Sales 5100 6900 7300 7500 19300 Selling Price per Unit 55 55 55 55 55 Total Sa... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Consider a market with only one firm that has a cost function C(Q) = Q +2Q. Since, there is only one firm in the market, the price depends on the quantity produced by the firm. The relationship...
-
Larkspur Games Inc. adjusts its accounts annually. The following information is available for the year ended December 31, 2025. 1. 2. 3. 4. 5. Purchased a 1-year insurance policy on June 1 for $1,620...
-
(7.5%) Standard and actual costs for direct materials for the manufacture of 1,000 units of product were as follows: Actual costs ...1,550 lbs. @ $9.10 Standard costs ... 1,600 lbs @ $9.00 Determine...
-
Figure 20.3 describes the Medicare Part D prescription drug benefi t. Look at the Web page www.partd-medicare.com/ in your area and determine the marginal coinsurance rates applicable in each...
-
Under what law and on what basis did the Federal district court find Microsoft guilty of violating the antitrust laws? What was the initial district courts remedy? How did Microsoft fare with its...
-
General Mills produces and sells a variety of food products in numerous countries. Access its home page and look at the company overview at the following address: www.generalmills.com Now consider...
-
Would the receipt of a large percentage of total fees from one particular audit client impair the independence of an accountant in public practice? What are the circumstances where this is...
-
Varina Trophies makes and sells trophies it distributes to little league ballplayers. The company normally produces and sells between 6,000 and 12,000 trophies per year. The following cost data apply...
-
Required information RWP 7 - 1 ( Algo ) Great Adventures Continuing Case [ The following information applies to the questions displayed below. ] Tony and Suzie see the need for a rugged all - terrain...
-
Pam Corporation purchased 75 percent of the outstanding voting stock of Sun Corporation for $4,800,000 on January 1, 2016. Sun's stockholders' equity on this date consisted of the following (in...
-
Your team of international developers will be developing a publicly accessible cloud-based application that may potentially house user Pli data, along with information about users' behaviors and activ
-
An initial deposit of $10,000 into investment account earning annual compound interest of 10.5% will grow to how much over 25 years
-
The general ledger of Vance Corporation as of December 31, includes the following accounts: Copyrights Deposits with advertising agency (will be used to promote goodwill) Discount on bonds payable...
-
Lori is a new hire and is keen to show her prowess in delta hedging to her boss. She reviews the put options on Waste Connections Ltd. and sells 60,000 put options. Spot price on the date of trading...
-
Q. 1 The Aylett Company Ltd has offered a contract that, if accepted, would significantly increase next year's activity levels. The contract requires the production of 20,000 kg of product Sigma and...
-
Darling Downs Investors Ltd (DDI) runs a portfolio whose performance is like the performance of the Australian share market as measured by the S&P/ASX 200 index. DDI would like some protection...
-
What is the term for the companies that help in moving a product from the manufacturer to the consumer? Question 2 options: wholesalers retailers intermediaries merchants
-
Determine which of the following limits exist. Compute the limits that exist. lim x-0 1- + 3x X
-
The Spivak Company was involved in the following treasury stock transactions during 20xx: a. Purchased 80,000 shares of its $1 par value common stock on the market for $2.50 per share. b. Purchased...
-
The Clockwork Corporation had the following stock outstanding from 20x6 through 20x9: Preferred stock: $100 par value, 8 percent cumulative, 10,000 shares authorized, issued, and outstanding Common...
-
Vanowski, Inc., was organized and authorized to issue 10,000 shares of $100 par value, 9 percent preferred stock and 100,000 shares of no-par, $5 stated value common stock on July 1, 20xx....
Study smarter with the SolutionInn App