Prepare a cash budget, assuming the balance of cash on November 1 is $220,000. Prepare the cash
Fantastic news! We've Found the answer you've been seeking!
Question:
Prepare a cash budget, assuming the balance of cash on November 1 is $220,000. Prepare the cash budget by month and in total...
Transcribed Image Text:
Julia has just got her MBA and started working for Mainely Lobster Inc., a manufacturer of frozen lobster rolls that are sold across the country. Julia is a management trainee in the CFO's office, and one of her job responsibilities is to help the CFO, Mr. Bean, prepare a master budget for the upcoming fiscal quarter ending on January 31, 2022 (i.e., the fiscal quarter includes financial results for November, December, and January). The company sells a foot-long lobster roll for $45 each. Budgeted unit sales for the next four months are as follows: November December January February March 44,000 Budgeted sales in units 40,000 46,000 38,000 36,000 Sales are collected in the following pattern: 40 percent in the month the sales are made, and the remaining 60 percent in the following month. The projected balance of accounts receivable on November 1, 2021, is $972,000, all of which will be collected in November. Bad debts are negligible and can be ignored. The company desires an ending finished goods inventory at the end of each moth equal to 10 percent of the budgeted unit sales for the next month. Half a pound of lobster meat is required to make one foot-long lobster roll. The company desires ending raw materials inventory at the end of each month equal to 20% of the following month's production needs. A pound of lobster meat is $50. Raw material purchases are paid for in the following pattern: 30 percent of a month's purchases is paid for in the month of purchase; the remaining 70 percent is paid for in the following month. The projected balance of accounts payable on November 1, 2021, is $651,700, all of which will be collected in November. Summing up costs of direct materials, direct labor, and manufacturing overhead, cost of goods sold is $35 per unit. (Assuming the cost of direct labor and manufacturing overhead is variable and it is $10 per unit. Based on the month's required production, the total cost is paid in cash at the end of each month.) Monthly selling and administrative expenses for the company are given below: Variable selling and administrative expenses $4 per unit Fixed selling and administrative expenses $50,000 in total, including $20,000 depreciation expense Monthly interest expense for its long-term notes payable is $600, paid in cash at the end of each month. Julia has just got her MBA and started working for Mainely Lobster Inc., a manufacturer of frozen lobster rolls that are sold across the country. Julia is a management trainee in the CFO's office, and one of her job responsibilities is to help the CFO, Mr. Bean, prepare a master budget for the upcoming fiscal quarter ending on January 31, 2022 (i.e., the fiscal quarter includes financial results for November, December, and January). The company sells a foot-long lobster roll for $45 each. Budgeted unit sales for the next four months are as follows: November December January February March 44,000 Budgeted sales in units 40,000 46,000 38,000 36,000 Sales are collected in the following pattern: 40 percent in the month the sales are made, and the remaining 60 percent in the following month. The projected balance of accounts receivable on November 1, 2021, is $972,000, all of which will be collected in November. Bad debts are negligible and can be ignored. The company desires an ending finished goods inventory at the end of each moth equal to 10 percent of the budgeted unit sales for the next month. Half a pound of lobster meat is required to make one foot-long lobster roll. The company desires ending raw materials inventory at the end of each month equal to 20% of the following month's production needs. A pound of lobster meat is $50. Raw material purchases are paid for in the following pattern: 30 percent of a month's purchases is paid for in the month of purchase; the remaining 70 percent is paid for in the following month. The projected balance of accounts payable on November 1, 2021, is $651,700, all of which will be collected in November. Summing up costs of direct materials, direct labor, and manufacturing overhead, cost of goods sold is $35 per unit. (Assuming the cost of direct labor and manufacturing overhead is variable and it is $10 per unit. Based on the month's required production, the total cost is paid in cash at the end of each month.) Monthly selling and administrative expenses for the company are given below: Variable selling and administrative expenses $4 per unit Fixed selling and administrative expenses $50,000 in total, including $20,000 depreciation expense Monthly interest expense for its long-term notes payable is $600, paid in cash at the end of each month.
Expert Answer:
Answer rating: 100% (QA)
Cash Budget Nov21 Dec21 Jan22 Total Qtr 1 Opening Cash Bal... View the full answer
Posted Date:
Students also viewed these finance questions
-
Consider two cigarette companies, PM Inc. and Brown Inc. If neither company advertises, the two companies split the market and earn $50 million each. If they both advertise, they again split the...
-
Prepare a cash budget for June. Donald Company has the following information: Cash Balance, May 31-45,000 Dividends paid in June- 12,000 Cash paid for operating expenses in June-39,600 Equipment...
-
Manchester Auditoriums Inc. provides the venue for many performers and talent companies touring the Southern New Hampshire region. Kathleen Johnson, treasurer of Manchester Auditoriums, needs to...
-
Cost-Volume-Profit (CVP) analysis can be used to determine the effect of changes in costs and volumes on a company's net profits. This project assignment assumes that you are newly hired as an...
-
What are the various regulatory bodies that regulate the accounting profession? Describe the functions of each.
-
Suppose that you time-reverse and delay a real-valued 32-point sequence x [n] to obtain x 1 [n] = x[32 ? n]. If x 1 [n] is used as the input for the system in figure, find an expression for y[32] in...
-
Adams Plastics, Inc., manufactures various plastic and synthetic products. Financial statement data for the firm follow: Required a. Using the given data, calculate items 1 through 8 below for 2019....
-
Wyoming Wholesale has gathered the following data on the number of shipments received and the cost of receiving reports for the first seven weeks of 2010. Number of Weekly Cost of Shipments Received...
-
Assume a stock price of $42; a risk-free rate of 3.5 percent per year, compounded continuously; a six-month maturity; and a standard deviation of 64 percent per year. If a six-month call with an...
-
Four key organizational complements must be in place to ensure successful implementation and use of a new system. Which two of these components seem to be missing at your store?
-
(5pts) Compute the area enclosed by the cross section and road bed template shown in the figure below. Use three level equation and check by the coordinate method. - 2.10 13.85 4.20 0.00 0.00 12.00...
-
Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the...
-
Clean and Bright Company makes 2 types of organic soaps: Original and Delicate. In the coming year, the company expects to sell 30,000 units of Original soaps and 15,000 units of Delicate soaps....
-
Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the...
-
Serendipity Sound, Inc., manufactures and sells compact discs. Price and cost data are as follows: Selling price per unit (package of two CDs) $ 25.00 Variable costs per unit: Direct material $ 10.50...
-
The marketing manager of Jordan Corporation has determined that a market exists for a telephone with a sales price of $22 per unit. The production manager estimates the annual fixed costs of...
-
Step 6. Refer to the pre-lab and implement the code for the method searchMaze () in Maze ActionThread. Don't forget to visit the goal when you find it. Step 7. The code to indicate steps in the...
-
On 1 July 2021, Croydon Ltd leased ten excavators for five years from Machines4U Ltd. The excavators are expected to have an economic life of 6 years, after which time they will have an expected...
-
Briefly justify the use of an annual predetermined manufacturing overhead rate as opposed to actual monthly manufacturing overhead.
-
How is a predetermined manufacturing overhead rate determined?
-
Wesley Manufacturing Company uses a predetermined plant-wide manufacturing overhead rate of \($25\) per direct labor hour. During April, Job 541 had \($3,000\) of direct materials assigned to it; 60...
Study smarter with the SolutionInn App