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...
-
Suppose you are an employee of Pactruck who just received 10,000 shares of restricted stock that vest in 4 years. Your current and expected tax rate on ordinary income is 35% and on capital gains is...
-
A telemarketer sells magazine subscriptions over the telephone. The probability of a busy signal or no answer is 65%. If the telemarketer does make contact, the probability of 0, 1, 2, or 3 magazine...
-
Think of a time you were talking with someone and felt yourself getting angry. How did you handle it? What steps would you take to keep from getting angry with a customer who was being unreasonable?
-
Which of the characteristics of a successful entrepreneur, discussed in the chapter, do you see in Nick Woodman? To what degree do you think these characteristics have contributed to GoPros success?
-
The table below shows information about the action figures available in a toy shop. Syed picks one at random for his niece. a) Work out P(shield female) as a fraction in its simplest form. b) Is the...
-
The CEO of Kuehner Development Co. has just come from a meeting with his marketing staff where he was given the latest market study of a proposed new shopping center, Parker Road Plaza. The study...
-
Pursuant to an action for dissolution and an accounting between the partners, A, B, C and D, the court has determined the following facts: (1) After liquidation of all assets, the firm has $92,000....
-
Several multilateral or regional development banks have been created since World War II. The last born is the Asian Infrastructure Investment Bank (AIIB) created effectively in January 2016. It...
-
Suppose you purchase a 10-year bond with 11% annual coupons. You hold the bond for four years, and sell it immediately after receiving the fourth coupon. If the bonds yield to maturity was 9.94% when...
-
Assume the current Treasury yield curve shows that the spot rates for six months, one year, and 1 years are 1%, 1.1%, and 1.3%, all quoted as semiannually compounded APRs. What is the price of a...
-
A BBB-rated corporate bond has a yield to maturity of 9%. A U.S. Treasury security has a yield to maturity of 7.5%. These yields are quoted as APRs with semiannual compounding. Both bonds pay...
-
The Eurozone was created in 1999 with countries including Austria, Belgium, France, Germany, and Ireland. New participant countries have joined sinceSlovenia (2007), Cyprus (2008), Malta (2008),...
-
What is a Goal Statement for a team facing struggling with a longer lab turn around, not meeting the standards and result in patients and providers dissatisfaction?
-
Find an equation of the given line. Slope is -2; x-intercept is -2
-
Mosca and Vespa are two sole traders with the financial statements (in euros) for the year ending 31 December as set out in Figure 7.10. Using the information contained in the financial statements,...
-
The following information has been extracted from the recently published statements of company D, as set out in Figure 7.11. Figure 7.11 Financial statements for company D as at 30 April The ratios...
-
Which of the following costs related to a building is NOT usually treated as an expense but is added to the asset? A. Repairs. B. Redecoration. C. Fitting new safety equipment. D. Cleaning.
Study smarter with the SolutionInn App