The Bear Corporation will begin business operations on January 1, 2021. Below is the anticipated SALES...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Bear Corporation will begin business operations on January 1, 2021. Below is the anticipated SALES BUDGET (in units): Jan. Feb. Mar. Apr. May 40,000 30,000 50,000 50,000 40,000 ADDITIONAL INFORMATION a. Ending finished goods inventory should be equal to 10% of next month's sales projection. b. Each unit requires 3 pounds of material at a raw material cost of $5 per pound. Labor cost is $10 per unit produced. C: d. Ending raw material inventory should be equal to 20% of next month's material requirement. e. Factory overhead is $18,000 per month of which $8,000 is for depreciation. t. All costs are paid in the month incurred except for purchases which is paid in the following month. 8. The selling price per unit is $100. REQUIRED: Using Excel, in good form: Prepare a SALES BUDGET for the first quarter (January through March). Prepare a PRODUCTION BUDGET for the first quarter (January through March). Prepare a Raw Materials PURCHASES BUDGET for the first quarter (Jan. through Mar.) Prepare a CASH DISBURSEMENTS budget for the first quarter (January through March). The Bear Corporation will begin business operations on January 1, 2021. Below is the anticipated SALES BUDGET (in units): Jan. Feb. Mar. Apr. May 40,000 30,000 50,000 50,000 40,000 ADDITIONAL INFORMATION a. Ending finished goods inventory should be equal to 10% of next month's sales projection. b. Each unit requires 3 pounds of material at a raw material cost of $5 per pound. Labor cost is $10 per unit produced. C: d. Ending raw material inventory should be equal to 20% of next month's material requirement. e. Factory overhead is $18,000 per month of which $8,000 is for depreciation. t. All costs are paid in the month incurred except for purchases which is paid in the following month. 8. The selling price per unit is $100. REQUIRED: Using Excel, in good form: Prepare a SALES BUDGET for the first quarter (January through March). Prepare a PRODUCTION BUDGET for the first quarter (January through March). Prepare a Raw Materials PURCHASES BUDGET for the first quarter (Jan. through Mar.) Prepare a CASH DISBURSEMENTS budget for the first quarter (January through March).
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
3. 2017 2018 2019 2020 2021 + H/C + H/C + - H/C + H/C + JAN 10 15 217 15 10 206 10 15 217 15 10 212 0 10 223 FEB 9 12 214 12 9 209 12 9 220 12 11 213 0 3 220 MAR 10 14 210 14 10 213 10 14 216 12 13...
-
The company ABC Inc. began operations on January 1 of the current year. During the month of January they carried out various business activities. His two partners contributed $ 20,000, in cash, each,...
-
The combined weights of the portfolio should be equal to 1 as in 0.100 as in 100%... so there is no way that the weights as be 1.50 and -0.5 it just doesn't make sense?
-
Use a CAS to perform the following steps for the given graph of the function over the closed interval. a. Plot the curve together with the polygonal path approximations for n = 2, 4, 8 partition...
-
What is the difference between the ex ante and the ex post real interest rate?
-
Two extrusion machines that manufacture steel rods are being compared. In a sample of 1000 rods taken from machine a. 960 met specifications regarding length and diameter. In a sample of 600 rods...
-
Explain the difference between a deferred tax liability and a deferred tax asset.
-
The book balance in the checking account of Johnson Enterprises as of October 31 is $5,718. The bank statement shows an ending balance of $5,217. The following information is discovered by (1)...
-
You plan to visit Geneva, Switzerland, in three months to attend aninternational business conference. You expect to incur a total costof SF7,000 for lodging, meals and transportation during your sta...
-
Upsidedown Cake Company produces dessert products for sale in grocery stores, but it also has a retail location. At the end of 2018, the company had $349,000 in accounts receivable before netting out...
-
There are received 889 Btu/sec of heat by 10 lb/sec of sulfur dioxide which undergo a steady flow isothermal process from saturated vapor at 300F; P = 0, K = 0. Find (a) delta s, delta p, delta h,...
-
Assume that a vector, x, is given as: x = [1, 23, 43, 72, 87,56,98,33] a) [10pts] Use a for loop to sum the elements in x and print the result by using fprintf. b) [10pts] Use a while loop to sum the...
-
Suresh Company reports the following segment (department) income results for the year. Sales: Expenses Avoidable Unavoidable Total expenses Income (loss) Department M $ 66,000 Department N $ 38,000...
-
Palouse Company completed the salary and wage payroll for the month of March. The payroll provided the following details: Salaries and wages earned by employees. Employee income taxes withheld...
-
Carmen Camry operates a consulting firm called Help Today, which began operations on December 1. On December 31, the company's records show the following selected accounts and amounts for the month...
-
(2) Find the error(s) if any, and fix the code: int sum(int n) {//assume n is non-negative if (0 == n) } else return 0: n+ sum (n-1);
-
BALANCE SHEET OF THE COMPANY: 20X2 20X1 LIABILITIES Line of credit 165,230 122,400 Long term debt 1,658,560 1,658,560 shareholder equity COmmon shares 415000 415000 (400,000 shares outstanindg) RE...
-
Kims Konstructions has assembled the following data for a proposed straw-reinforced brick maker (SRBM): SRBM Cost: $26,000 Life: 5 years Revenue (p.a.) $11,000 Operating Expenses (p.a.) $3,000...
-
Suppose the argument in Exercise 8.81 was to be settled using a sample of size 4; find a and b.
-
Start with the point (5, 5) and add at least four ordered pairs, (x, y), to make a set of ordered pairs that display the following properties. Show that your sample satisfies the requirements. a. The...
-
Albert Michelson, the first American citizen to be awarded a Nobel Prize in Physics, conducted many experiments in determining the velocity of light in air. Following is an excerpt of five trials of...
-
8. YOU BE THE JUDGE WRITING PROBLEM Nationwide Insurance Co. circulated a memorandum asking all employees to lobby in favor of a bill that had been introduced in the Pennsylvania House of...
-
10. ROLE REVERSAL Prepare a short-answer question in which an employee alleges that his discharge violated public policy, but you think a court would not agree.
-
9. During a job interview with Venetia, Jack reveals that he and his wife are expecting twins. Venetia asks him if he is planning to take a leave once the babies are born. When Jack admits that he...
Study smarter with the SolutionInn App