Answered step by step
Verified Expert Solution
Question
1 Approved Answer
L . C . Body Boards Inc. Budgeting Project As the head accountant for L . C . Body Boards Inc., you are responsible for
L C Body Boards Inc. Budgeting Project
As the head accountant for L C Body Boards Inc., you are responsible for preparing the companys master budget for the first quarter of XX 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
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 XX
Sales results from the prior year are:
Last Year Units Sold
January
February
March
April
May
Unit Sales are to expected increase above last years sales and each unit sells for $
All sales are on credit. The company expects to collect
of sales in the month of sale,
of sales in the month following the sale,
percent will be uncollectable Bad Debt Debts Expense is recognized in the month of sale
The company gives credit terms of EOM, nEOM second month. Accounts receivable at the end of last year totaled $ This represents the collectable amount of December sales that will be collected in January.
Management prefers to maintain ending finished goods inventory equal to of next month's sales. The Finished Goods Inventory on December of the prior year was 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. Budgeting Project
Step
L C Body Boards Inc. is now preparing the budget for direct materials purchases, direct labor, and manufacturing overhead.
Each unit production requires pounds Foam X pound Plastic Z
LC Body Boards pays $ per pound $ per pound.
Management prefers to maintain ending raw materials inventory equal to materials of needed production for the next month. Raw Material inventory on December for Foam X was pounds and for Plastic Z was pounds.
All direct materials are purchased on credit. L C Body Boards pays of purchases in the month of purchase and the following month. L C Body Boards pays all invoices in a timely manner which have credit terms of net The accounts payable on December were $
Each unit of production requires direct labor hours at a cost of $ per hour.
Variable overhead costs are:
Indirect materials $ per unit
Indirect Labor $ per unit
Other $ per unit
Fixed overhead costs per month:
Salaries $
Rent $
Depreciation $
REQUIRED:
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 xx
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 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 xx
L C Body Boards Inc. Budgeting Project
Step
L C Body Boards Inc. expects the following as pertaining to the capital expenditures and cash budgets.
L C Body Boards Inc. expects the following monthly Selling and Administrative Expenses
Salaries $ Per Unit
Rent $
Advertising $
Depreciation $
Other $
Sales Commissions $
Capital Expenditures
The company plans to purchase selling and administrative equipment totaling $ in March XX
The company plans to purchase Production equipment totaling $ in March XX
Both will be purchased at the end of March from operating cash flow and will not affect depreciation expenses for the first quarter.
Cash Budget
The company has a credit line of $ for operations with an interest rate of APR. Interest payments for the month are based on the beginning balance of the line of credit. At the end of every month, the cash balance should be a minimum of $
The cash budget should include an estimate of amounts to be borrowed or returned to t
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started