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)
-
Calculate UTX's current and quick ratios for each year 2010-2012.
-
Describe the calculation of cost of goods sold when using the periodic inventory system.
-
Consider the Latin Square design and data from Bliss and Rose [1940] shown in Table 5.9. a. Use R to compute the ANOVA table. Interpret the results. b. Estimate the treatment effects. Interpret the...
-
An accountant wishes to predict direct labor cost (y) on the basis of the batch size (x) of a product produced in a job shop. Data for 12 production runs are given in Table 13.5, along with the Excel...
-
Decomposition of Vectors Question 1 Let u = (0) (5 points) 3 and v = -2 2 (a) (2 points) decompose u into two perpendicular vectors u = uu, such that u|| is parallel to v. (b) (2 points) decompose v...
-
Pay Corporation acquired a 75 percent interest in Sue Corporation for $600,000 on January 1, 2011, when Sue's equity consisted of $300,000 capital stock and $100,000 retained earnings. The fair...
-
Conglomerate Inc., a major U.S. wireless carrier, has teamed up with a PC manufacturer to form a joint venture, Netlink, to develop, produce and market a hybrid product integrating a Personal Digital...
-
Noelia works on the assembly line for Frozen Foods. Noelia and other Frozen Foods employees designate the International Union of Food Workers (IUFW) as their bargaining representative. Without...
-
Ulrich is a general partner and Lee and Carol are limited partners in GLC Associates, a limited partnership. Lee and Carol a. have fewer managerial powers than Ulrich. b. cannot sue on behalf of the...
-
In terms of a security agreement, what constitutes default?
-
Tabina and Adam are the directors and majority shareholders of U.S. Imports, Inc., and Overseas Corporation. U.S. Imports owes $5,000 to International Transport, Inc. To avoid the debt, Tabina and...
-
Odette believes that the Power Utility Corporation (PUC) discriminated against her on the basis of race. She files a suit against PUC under Title VII. To establish a prima facie case of employment...
-
Please answer the following using Matlab. ??????? Problem 1: Define \( a=2, b=5, c=-3 \) in Octave, then use Octave to evaluate the following expressions: a) \( \frac{1}{2} a^{3}-\frac{(a-b)^{2}}{a-b...
-
Federated Shipping, a competing overnight delivery service, informs the customer in Problem 65 that they would ship the 5-pound package for $29.95 and the 20-pound package for $59.20. (A) If...
-
A golf ball is hit on a level fairway. When it lands, its velocity vector has rotated through an angle of 90. What was the launch angle of the golf ball? Pyo By Dyz =0 Uso Range R x max dya
-
Can a nonzero vector have a zero x-component? Explain.
-
Using the reconciliations of this chapter and the information in Chapter 2, comment on the adjustments necessary when moving from German or UK accounting to US or IFRS accounting. Chapter 2 Table 5.8...
Study smarter with the SolutionInn App