L. C. Body Boards Inc. Budgeting Project As the head accountant for L. C. Body Boards...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
L. C. Body Boards Inc. Budgeting Project As the head accountant for L. C. Body Boards Inc., you are responsible for preparing the company's master budget for the first quarter of 20XX. The administrative and divisional managers have prepared the appropriate information (found below) for you to prepare the budget. In addition to the compiled information, you will also find the budgets, reports, questions, and statements required by the CFO. Step 1 L. C. Body Boards Inc. produces Body Boards for sale at local surf shops. The company is in the process of creating a master budget for the first quarter of 20XX. Sales results from the prior year are: Last Year Units Sold January 190,000 February 210,000 March 215,000 April 199,000 May 194,000 Unit Sales are to expected increase 14% above last year's sales and each unit sells for $53.00. All sales are on credit. The company expects to collect 70% of sales in the month of sale, 28% of sales in the month following the sale, 2% percent will be uncollectable (Bad Debt Debts Expense is recognized in the month of sale). The company gives credit terms of 2/EOM, n/EOM second month. Accounts receivable at the end of last year totaled $ 485,000. This represents the collectable amount of December sales that will be collected in January. Management prefers to maintain ending finished goods inventory equal to 12% of next month's sales. The Finished Goods Inventory on December 31 of the prior year was 32,500 units. REQUIRED: a) Prepare a sales and cash collections budget for L. C. Body Boards Inc. (For all budgets show amounts for January, February, March, and the total for quarter, also all budgets need to be to two decimal places) b) Prepare a production budget for L. C. Body Boards Inc. L.C Body Boards Inc. Sales and Collections Budget First Quarter of year 2024 Quarter 1 4Q previous year January February March April May Total Budgeted Sales (Units) Selling Price per Unit Total Sales Sales on Account Collections in quarter of sale Less Discounts (January) Collections in qtr after sale Total Collections Bad Debt Expense 23-Dec January Budgeted sales (unit) Add desired ending inventory Total needs Less beginning inventory Required production L.C Body Boards Inc. Production Budget First Quarter of year 2024 February Quarter March April Total L. C. Body Boards Inc. Budgeting Project As the head accountant for L. C. Body Boards Inc., you are responsible for preparing the company's master budget for the first quarter of 20XX. The administrative and divisional managers have prepared the appropriate information (found below) for you to prepare the budget. In addition to the compiled information, you will also find the budgets, reports, questions, and statements required by the CFO. Step 1 L. C. Body Boards Inc. produces Body Boards for sale at local surf shops. The company is in the process of creating a master budget for the first quarter of 20XX. Sales results from the prior year are: Last Year Units Sold January 190,000 February 210,000 March 215,000 April 199,000 May 194,000 Unit Sales are to expected increase 14% above last year's sales and each unit sells for $53.00. All sales are on credit. The company expects to collect 70% of sales in the month of sale, 28% of sales in the month following the sale, 2% percent will be uncollectable (Bad Debt Debts Expense is recognized in the month of sale). The company gives credit terms of 2/EOM, n/EOM second month. Accounts receivable at the end of last year totaled $ 485,000. This represents the collectable amount of December sales that will be collected in January. Management prefers to maintain ending finished goods inventory equal to 12% of next month's sales. The Finished Goods Inventory on December 31 of the prior year was 32,500 units. REQUIRED: a) Prepare a sales and cash collections budget for L. C. Body Boards Inc. (For all budgets show amounts for January, February, March, and the total for quarter, also all budgets need to be to two decimal places) b) Prepare a production budget for L. C. Body Boards Inc. L.C Body Boards Inc. Sales and Collections Budget First Quarter of year 2024 Quarter 1 4Q previous year January February March April May Total Budgeted Sales (Units) Selling Price per Unit Total Sales Sales on Account Collections in quarter of sale Less Discounts (January) Collections in qtr after sale Total Collections Bad Debt Expense 23-Dec January Budgeted sales (unit) Add desired ending inventory Total needs Less beginning inventory Required production L.C Body Boards Inc. Production Budget First Quarter of year 2024 February Quarter March April Total
Expert Answer:
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
As the head accountant for L . C . Body Boards Inc., you are responsible for preparing the company s master budget for the first quarter of 2 0 XX . The administrative and divisional managers have...
-
Please watch the video link and answer the following questions. https://youtu.be/VtvjbmoDx-I On January 22,1984, Apple produced one of the most famous Super Bowl ads of all time. Directed by Ridley...
-
Yancey Co. receives $300,000 when it issues a $300,000, 10%, mortgage note payable to finance the construction of a building at December 31, 2017. The terms provide for annual installment payments of...
-
For journal entries 1 through 12, indicate the explanation that most closely describes it. You can use explana A. To record receipt of unearned revenue. B. To record this period's earning of prior...
-
Melissa Khan alleges that on May 27, 2004, she entered into a lease and warranty agreement with Riverbank Motors Corporation, Inc. (the Dealership), for a new, 2004 Volkswagen Toureg (the Vehicle),...
-
Anya Clark opened Anyas Cleaning Service on July 1, 2017. During July, the following transactions were completed. July 1 Anya invested $20,000 cash in the business. 1 Purchased used truck for...
-
CanMS-EXCEL connect to an ORACLE database using JDBC? I've spent an hour finding the answer to the question and I'm still not sure. Could you explain in detail?
-
As the accountant for Runson Moving Company, you are preparing the companys annual return, Form 940 and Schedule A. Use the following information to complete Form 940 and Schedule A on pages 5-40 to...
-
b) A 1.5MeV gamma undergoes Compton scattering. i.) What is the maximum energy the Compton electron can have? ii.) What is the minimum energy of the scattered photon? c) i.) Define neutron...
-
Based on the following scenario, on which day was the gift completed for tax purposes? Day 1: I write a check to a charity Day 2: I put the check in the post office mailbox with proper address and...
-
suggest statements of understanding, applying, analyzing, evaluating, and creating for the following: I can interpret financial data for up to 10 million dollars in revenue sales; Well enough to...
-
The limited liability aspect of common stock limits Multiple choice question. ownership rights. participation in the company's future profitability. the risk of loss. potential gains and potential...
-
when a central bank buys financial assets from a commercial bank. Who decides the interest rates
-
You decide to investigate Cathy Wood's Ark Investments Innovation ETF (ARKK). You are hoping to invest in growth in the tech sector and capture long term secular change.
-
Write a paper on U.S. Health Care, It is essential to identify, examine, and understand the history and foundations of health care in the U.S. as this will be the foundation for understanding health...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19 year-old nanny $125 per week for 48 weeks during the current year. a. What is the employers portion of...
-
True Printing Company of Baltimore has applied for a loan. Its bank has requested a budgeted balance sheet at April 30, 2016, and a budgeted statement of cash flows for April. The March 31, 2016,...
-
Members of the board of directors of Safety Step have received the following operating income data for the year ended May 31, 2016: Members of the board are surprised that the industrial systems...
-
On January 3, 2016, Quick Delivery Service purchased a truck at a cost of $90,000. Before placing the truck in service, Quick spent $2,500 painting it, $1,800 replacing tires, and $4,700 overhauling...
-
Smart Manufacturing Systems Pty Ltds accountant recently prepared the following data from the companys accounting records for the year ended 30 June 2019. Factory overhead is applied at the rate of...
-
During the year ended 30 June 2019, Beautiful Bottles Pty Ltd incurred the following costs in connection with its production activities. Required (a) Calculate the relationship between factory...
-
Telecommunications company Toronto Ltd signed a 15year deal to sell capacity on its cable network to a rival company for $200 million. The deal was completed on the last day of Toronto Ltds financial...
Study smarter with the SolutionInn App