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
-
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...
-
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...
-
Assume that you are considering purchasing stock as an investment. You have narrowed the choice to Disc.com and Holiday Shops and have assembled the following data. Selected income statement data for...
-
Chartreuse Co. has purchased a brand new machine to produce its High Flight line of shoes. The machine has an economic life of six years. The depreciation schedule for the machine is straight-line...
-
What happens if you specify an invalid format string?
-
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...
-
Pioneer Inc. wants to invest $557,302 today. The expected returns in years 1, 2, and 3 are $247,615, $180,383, and $335,481, respectively. If the rate of return on investment must be at least 14%,...
-
The company in question 76 further claims that only 2 % of the cups contain more than half the fat of regular yogurt. What is the probability of our seeing more than 12 cups out of 400 (which is what...
-
Assume that a grower of flower bulbs sells its annual output of bulbs to an Internet retailer for $70,000. The retailer, in turn, brings in $160,000 from selling the bulbs directly to final...
-
What are the expected value and standard deviation of the random variable generated in question 79? Question 79 In a game, a player rolls two dice and counts how many points he gets between them....
-
A piston-cylinder assembly contains 0.5 kg of water at 50C and 500 kPa. It is then isobarically heated until all the water is vaporized. What is the fi nal temperature and volume?
-
Of 500 students in a high school, 72 % have indicated that they are interested in attending college. What is the probability of selecting a random sample of 50 students wherein the sample proportion...
-
Why use Selenium as Test Automation tool?
-
Determine the annual percentage yield for a loan that charges a monthly interest rate of 1.5% and compounds the interest monthly.
-
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...
-
Some FIR filters present a rational transfer function: (a) Show that the transfer function \[H(z)=\frac{\left(r^{-1} z ight)^{-(M+1)}-1}{r e^{\mathrm{j} 2 \pi /(M+1)} z^{-1}-1}\] corresponds to an...
-
Show that if two given networks are described by \(Y_{i}=\sum_{j=1}^{M} T_{i j} X_{j}\) and \(Y_{i}^{\prime}=\) \(\sum_{j=1}^{M} T_{i j}^{\prime} X_{j}^{\prime}\), then these networks are...
-
Design second-order lowpass and highpass blocks, and combine them in cascade, to form a bandpass filter with passband \(0.3 \leq \omega \leq 0.4\), where \(\omega_{\mathrm{s}}=1\). Plot the resulting...
Study smarter with the SolutionInn App