Bell Inc. is a distributor of computer monitors. Julie, the chief controller of Bell inc., is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bell Inc. is a distributor of computer monitors. Julie, the chief controller of Bell inc., is preparing a master budget for the first quarter of 2022. Below are the accounting records of the last quarter of 2021: Sales $540,000 $600,000 $400,000 Year-Month October 2021 November 2021 December 2021 The selling price was $50 per unit. The cost of goods sold was 60% of sales. The net income after tax was $212,500. The balance of accounts payable as of December 31, 2021 was $70,650. The balance of retained earnings as of December 31, 2021 was $1,560,400. Julie predicts sales in January, February, and March of 2022 to be $420,000, $480,000, and $540,000, respectively. She also estimates that sales in April and May of 2022 will be 500 units higher than the prior month and sales in June of 2022 will drop by 1,500 units. All sales are on account. The collection pattern remains the same as in prior years: 50% collected in the month of sale, 40% collected in the first month following the sale, and the remaining collected in the second month following the sale. In prior years, Bell Inc. used to keep 15% of the next month's sales as ending inventory. Starting from 2022, Bell Inc. plans to maintain 10% of the next two months' sales as ending inventory, since the product market demand will likely experience abnormal fluctuations in the post-pandemic period. Bell Inc. has renewed the purchase agreement with its long-term supplier, Mountain View Corp., which will continue to sell computer monitors to Bell Inc. in 2022. As stated in the renewed agreement, Bell Inc. will pay Mountain View Corp. 80 % in the month following the purchase and the remaining in the second month following the purchase. Given the rising labor cost, Mountain View Corp. will charge 25 % more on each monitor sold. As a result, Bell Inc. plans to increase its selling price by 20%. Operating expenses in the first quarter of 2022 are estimated to be the following (warehouse rent and insurance will be pre-paid at the beginning of the quarter and other expenses will be paid in the month incurred except for depreciation): $8,000 per month $4 per unit sold for the first 5,000 units sold in a month and $3 per unit sold for any additional units sold in a month Advertising Shipping Salesperson salary Sales commission Warehouse rent Depreciation Utilities Insurance $13,000 per month 5% of monthly sales 15,000 per month $2,000 per month $2,100 per month $800 per month $22,500 in January Office repair As usual, income taxes are 15% of pre-tax income and are calculated at the end of each quarter and due in the first month after the quarter-end. In 2022, Bell Inc. plans to pay cash dividends of $4,800 in January and $21,500 in February and purchase two cash register machines, which cost $11,500 per unit and require cash payment. Bell Inc. has $30,000 cash on hand on December 31, 2021. The company wants to maintain a minimum cash balance of $25,000. The company maintains a 12% open line of credit for the amount of $50,000 with Sequoia Bank. The borrowing must be in increments of $1,000. The company borrows and repays on the last day of the month. The interest is accrued and paid every month. Required: Prepare a cash budget for January, February, March, and the quarter in total. (13 marks) a. b. Determine the budgeted ending balance of retained earnings as of March 31, 2022. Show all workings. (7 marks) Bell Inc. is a distributor of computer monitors. Julie, the chief controller of Bell inc., is preparing a master budget for the first quarter of 2022. Below are the accounting records of the last quarter of 2021: Sales $540,000 $600,000 $400,000 Year-Month October 2021 November 2021 December 2021 The selling price was $50 per unit. The cost of goods sold was 60% of sales. The net income after tax was $212,500. The balance of accounts payable as of December 31, 2021 was $70,650. The balance of retained earnings as of December 31, 2021 was $1,560,400. Julie predicts sales in January, February, and March of 2022 to be $420,000, $480,000, and $540,000, respectively. She also estimates that sales in April and May of 2022 will be 500 units higher than the prior month and sales in June of 2022 will drop by 1,500 units. All sales are on account. The collection pattern remains the same as in prior years: 50% collected in the month of sale, 40% collected in the first month following the sale, and the remaining collected in the second month following the sale. In prior years, Bell Inc. used to keep 15% of the next month's sales as ending inventory. Starting from 2022, Bell Inc. plans to maintain 10% of the next two months' sales as ending inventory, since the product market demand will likely experience abnormal fluctuations in the post-pandemic period. Bell Inc. has renewed the purchase agreement with its long-term supplier, Mountain View Corp., which will continue to sell computer monitors to Bell Inc. in 2022. As stated in the renewed agreement, Bell Inc. will pay Mountain View Corp. 80 % in the month following the purchase and the remaining in the second month following the purchase. Given the rising labor cost, Mountain View Corp. will charge 25 % more on each monitor sold. As a result, Bell Inc. plans to increase its selling price by 20%. Operating expenses in the first quarter of 2022 are estimated to be the following (warehouse rent and insurance will be pre-paid at the beginning of the quarter and other expenses will be paid in the month incurred except for depreciation): $8,000 per month $4 per unit sold for the first 5,000 units sold in a month and $3 per unit sold for any additional units sold in a month Advertising Shipping Salesperson salary Sales commission Warehouse rent Depreciation Utilities Insurance $13,000 per month 5% of monthly sales 15,000 per month $2,000 per month $2,100 per month $800 per month $22,500 in January Office repair As usual, income taxes are 15% of pre-tax income and are calculated at the end of each quarter and due in the first month after the quarter-end. In 2022, Bell Inc. plans to pay cash dividends of $4,800 in January and $21,500 in February and purchase two cash register machines, which cost $11,500 per unit and require cash payment. Bell Inc. has $30,000 cash on hand on December 31, 2021. The company wants to maintain a minimum cash balance of $25,000. The company maintains a 12% open line of credit for the amount of $50,000 with Sequoia Bank. The borrowing must be in increments of $1,000. The company borrows and repays on the last day of the month. The interest is accrued and paid every month. Required: Prepare a cash budget for January, February, March, and the quarter in total. (13 marks) a. b. Determine the budgeted ending balance of retained earnings as of March 31, 2022. Show all workings. (7 marks)
Expert Answer:
Answer rating: 100% (QA)
ANSWER paaticu laas Janvaay febougay Muach 420000 Totell Sale 4800... View the full answer
Posted Date:
Students also viewed these accounting questions
-
The Central Hydraulic Supply Company is a distributor of hydraulic supplies in the Midwest. Central handles standard fittings, tubing, and similar items. Generally Central carries an entire product...
-
The Thomas Supply Company Inc. is a distributor of gas-powered generators. As with any business, the length of time customers take to pay their invoices is important. Listed below, arranged from...
-
The Wallace Company of Houston is a distributor of pipes, valves, and fittings to the refining, chemical, and petrochemical industries. The company was a recent winner of the Malcolm Baldrige...
-
In Problems 67 90, multiply the polynomials using the special product formulas. Express your answer as a single polynomial in standard form. (x-4)
-
Sketch a free-body diagram of each element in the figure. Compute the magnitude and direction of each force using an algebraic or vector method, asspecified. 100 lbf 12 in 6 in
-
Explain several purposes that may be served by preparing a worksheet (or using computer software that achieves the goals of a worksheet).
-
Explain the difference between a reversal of a write-down and a holding gain.
-
Price and efficiency variances. Peterson Foods manufactures pumpkin scones. For January 2009, it budgeted to purchase and use 15000 pounds of pumpkin at $0.89 a pound. Actual purchases and usage for...
-
i need help Find the domain of each Function. Questions F (X ) = 2,3 - x2+3 57 F ( x ) = x- 2 5 9 g (x) = v7-x Find and samplely each expression of Fly ) = x2 - 1 71 Question 8 F( x-3) 7 5 auntwon 9...
-
Which series has the highest beta. BraveNewCoin Liquid Index for Bitcoin 1D BNC Trading Brave Ne Yellow Green Blue Orange
-
Comprehensively discuss the impact of disruptions on both operational and financial performance of a supply chain to an event such as Covid-19. What kind of operations and risk management practices...
-
Discuss the concept of epigenetic inheritance and its implications for the transmission of phenotypic traits across generations, with a focus on DNA methylation, histone modification, and non-coding...
-
4. A boy with a mass of 65.2kg and maintaining a velocity of 1.1m/s, rides his bike up a hill with an elevation gain of 43 meters. It takes the boy 1.5 minutes to make it up the hill. What was his...
-
Assume you are a portfolio manager for an institutional investment company. Your client asks you to explain what risk factor sensitivity is and what it seeks to measure.
-
For this C++ program can you please complete Time.cpp file using overloaded operators. Below are the screenshots that can you be helpful. So can you please complete the Time.cpp file with the C++...
-
1 9 8 9 C Corporation had gross income of $ 2 5 0 , 0 0 0 , cost of goods sold of $ 8 0 , 0 0 0 . entertainment of $ 2 0 , 0 0 0 , lobbying of $ 5 , 0 0 0 , other expenses of $ 8 8 , 0 0 0 . What is...
-
What types of questions does qualitative research more commonly address
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
How does the general manager pinpoint his or her organizations weaknesses?
-
What factors influence employees willingness to support efforts to increase productivity?
-
What is the result if the firm can lower the cost to the consumer of a premium product to equal the prices of competitors less-effective products?
Study smarter with the SolutionInn App