IL. 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:
IL. 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. L. C. Body Boards Inc. Budgeting Project Step 2 L. C. Body Boards Inc. is now preparing the budget for direct materials purchases, direct labor, and manufacturing overhead. Each unit production requires L.C. Body Boards pays 6 pounds Foam X $3.75 per pound .5-pound Plastic Z. $10 per pound. Management prefers to maintain ending raw materials inventory equal to materials 30% of needed production for the next month. Raw Material inventory on December 31 for Foam X was 385,000 pounds and for Plastic Z was 32,000 pounds. All direct materials are purchased on credit. L. C. Body Boards pays 72% of purchases in the month of purchase and 28% the following month. L. C. Body Boards pays all invoices in a timely manner and receives a 1% cash discount on all of the raw materials purchases. The accounts payable on December 31 were $1,650,000. Each unit of production requires 0.6 direct labor hours at a cost of $21.00 per hour. Variable overhead costs are: Accounting Sales results from the prior year are: Last Year Units Sold January 190,000 February 210,000 March 215,000 199,000 April May 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. $ 0.27 per unit $ 1.20 per unit gerial Accoun Indirect materials Indirect Labor Other Fixed overhead costs per month: Salaries Rent $196,000 $18,000 Depreciation REQUIRED: $ 1.12 per unit a) Prepare two direct materials budgets, one for the Foam X and the other for the Plastic Z for L. C. Body Boards b) Prepare a single cash disbursements budget for the material purchases for L. C. Body Boards. c) Prepare a schedule showing the cost of ending inventory for raw materials as of March 31, 20xx d) Prepare a direct labor budget for L. C. Body Boards Inc. Show the cash disbursements for labor at the bottom of the budget. e) Prepare a manufacturing overhead budget for L. C. Body Boards Inc. Show cash disbursements for overhead at the bottom of the budget. Show a calculation of the per unit cost of the manufacturing overhead ROUNDED to 3 decimal places. (Note you must use the excel round function for this calculation) f) Prepare a schedule for the cost of Finished Goods Inventory as of March 31, 20xx. Budgeted production (Pounds) Raw materials needed per pound Production needs per pound Add desired ending inventory per pound Total needs (pounds) Less begin inventory of raw materials Raw Materials to be purchased Cost of raw materials Cost of raw materials to be purchased Direct Materials cost per pound Required production of product Direct Labor hours Total Direct Labor Hours needed Direct Labor cost per hour Total Direct Labor cost Direct labor cost per pound L.C body boards inc Direct Materials Budget - Foam First Quarter of year 2024 1 2 L.C Body Boards Inc. Direct Labor Budget First Quarter of year 2024 1 Quarter 3 4 Total 2 Quarter 3 4 Total IL. 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. L. C. Body Boards Inc. Budgeting Project Step 2 L. C. Body Boards Inc. is now preparing the budget for direct materials purchases, direct labor, and manufacturing overhead. Each unit production requires L.C. Body Boards pays 6 pounds Foam X $3.75 per pound .5-pound Plastic Z. $10 per pound. Management prefers to maintain ending raw materials inventory equal to materials 30% of needed production for the next month. Raw Material inventory on December 31 for Foam X was 385,000 pounds and for Plastic Z was 32,000 pounds. All direct materials are purchased on credit. L. C. Body Boards pays 72% of purchases in the month of purchase and 28% the following month. L. C. Body Boards pays all invoices in a timely manner and receives a 1% cash discount on all of the raw materials purchases. The accounts payable on December 31 were $1,650,000. Each unit of production requires 0.6 direct labor hours at a cost of $21.00 per hour. Variable overhead costs are: Accounting Sales results from the prior year are: Last Year Units Sold January 190,000 February 210,000 March 215,000 199,000 April May 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. $ 0.27 per unit $ 1.20 per unit gerial Accoun Indirect materials Indirect Labor Other Fixed overhead costs per month: Salaries Rent $196,000 $18,000 Depreciation REQUIRED: $ 1.12 per unit a) Prepare two direct materials budgets, one for the Foam X and the other for the Plastic Z for L. C. Body Boards b) Prepare a single cash disbursements budget for the material purchases for L. C. Body Boards. c) Prepare a schedule showing the cost of ending inventory for raw materials as of March 31, 20xx d) Prepare a direct labor budget for L. C. Body Boards Inc. Show the cash disbursements for labor at the bottom of the budget. e) Prepare a manufacturing overhead budget for L. C. Body Boards Inc. Show cash disbursements for overhead at the bottom of the budget. Show a calculation of the per unit cost of the manufacturing overhead ROUNDED to 3 decimal places. (Note you must use the excel round function for this calculation) f) Prepare a schedule for the cost of Finished Goods Inventory as of March 31, 20xx. Budgeted production (Pounds) Raw materials needed per pound Production needs per pound Add desired ending inventory per pound Total needs (pounds) Less begin inventory of raw materials Raw Materials to be purchased Cost of raw materials Cost of raw materials to be purchased Direct Materials cost per pound Required production of product Direct Labor hours Total Direct Labor Hours needed Direct Labor cost per hour Total Direct Labor cost Direct labor cost per pound L.C body boards inc Direct Materials Budget - Foam First Quarter of year 2024 1 2 L.C Body Boards Inc. Direct Labor Budget First Quarter of year 2024 1 Quarter 3 4 Total 2 Quarter 3 4 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
-
Exercise 2: Pricing European options in the Black-Scholes market (12 Marks) Suppose that T = (0,), that (W)te[0,T] is a standard Brownian motion and that the price of a stock at time t is given by a...
-
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...
-
Given your calculations above, why is it important to consider the degrees of freedom and critical value for an ANOVA when deciding whether to reject or fail to reject the null hypothesis? What could...
-
Debate on Causes of Unemployment Two economists are debating the cause of a high unemployment rate. One economist argues that there is not enough government spending. The other says high unemployment...
-
You are evaluating two companies as possible investments. The two companies, which are similar in size, are commuter airlines that fly passengers up and down the West Coast. All other available...
-
What is the annualised amount of the net benefits from the project in Question 46.11A? Data from Question 46.11 What is the payback on a project requiring 40,000 initial investment that has a net...
-
XYZ Corporation has \($500\) million in zero coupon debt outstanding, due in five years. The firm had earnings before interest and taxes of \($40\) million in the most recent year (the tax rate is...
-
OGrady Apparel Company was founded nearly 160 years ago when an Irish merchant named Garrett OGrady landed in Los Angeles with an inventory of heavy canvas, which he hoped to sell for tents and wagon...
-
The Crane Hotel opened for business on May 1, 2022. Here is its trial balance before adjustment on May 31. CRANE HOTEL Trial Balance May 31, 2022 Debit Credit Cash $2,403 Supplies 2,600 Prepaid...
-
What are the triads using roman numerals and figured bass numbers for this excerpt? 30-3. Use Roman numerals and figured bass numbers to identify triads in these works. a. Schubert, "Death and the...
-
You are asked to conduct design analysis for two embedded systems needed for a modern car: ES1 will be used for ABS braking system control and ES2 will be used for smart display and entertainment...
-
Marwick's Planos, Incorporated, purchases planos from a manufacturer for an average cost of $1,489 per unit and then sells them to retail customers for an average price of $2,600 each. The company's...
-
My first example of a healthy organization is my current organization, I came to this organization because of the health and the culture. This organization is a private non-profit agency, one of 21...
-
This is for my Organizational Behavior class. This is due by midnight tonight, July 30. Please help!! The organization I have chosen is a rural health care facility...a clinic. What are the basic...
-
Playten Ltd is a manufacturer of various pet accessories. They carry many lines of products that are produced in their main factory in Arthur. On October 5, 2021 the CFO, Cecily Jones called a...
-
Why is survey research so commonly used in health psychology? Find an example of a survey used in a health psychology program or research study and describe some of the questions that it includes?...
-
How should the fund directors evaluate the quality of services provided by the transfer agent? Do you think customer satisfaction on a service survey would be influenced by fund performance?
-
Define cultural intelligence. Cite the books or journal articles you found in Capella's library. Explain why cultural intelligence is important for HR practitioners and other organizational managers.
-
Match the following terms with the correct definitions: 1. Costs that do not change in total over wide ranges of volume. 2. Technique that estimates profit or loss results when conditions change. 3....
-
Review the following activities of the capital budgeting process: a. Budget capital investments. b. Project investments cash flows. c. Perform post-audits. d. Make investments. e. Use feedback to...
-
Jenna Lindsay works at College of Boston and is paid $40 per hour for a 40-hour workweek and time-and-a-half for hours above 40. Requirements 1. Compute Lindsays gross pay for working 54 hours during...
-
Alexa Inc. recorded the following deferred tax amounts. If the company had current tax expense of \(\$ 26,000\) in 2020 , determine total income tax expense for 2020. Deferred tax liability Deferred...
-
Aquafena Inc. recognized taxable income of \(\$ 100,000\) for the year ended December 31, 2020. Aquafena calculated a deferred tax asset and a deferred tax liability of \(\$ 12,000\) and \(\$...
-
Assuming the same information from Brief Exercise 18-21, record the income tax journal entry on December 31, 2020. Assume zero beginning balances in deferred tax accounts. Exercise 18-21 On December...
Study smarter with the SolutionInn App