Q1- Operating Budget (15 points) You have been asked by your VP of Finance to put...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q1- Operating Budget (15 points) You have been asked by your VP of Finance to put together the Operating Budgets and the Projected Income Statement for Comfy Bedding Co, using the information provided You can decide to show the budget either in QUARTERLY or MONTHLY format (Hint - whichever time period you choose, please ensure your number matches with that particular period) BONUS PTS - What is the budget cash outflow for inventory purchase next year? (Assumes 70% of current quarter purchases gets paid SAME quarter, and 30% NEXT quarter) - 3 points Comfy Bedding Co. LY Q1 Sale - Units (equally divided by 3 - if show monthly) LY Q2 Sale - Units (equally divided by 3 - if show monthly) LY Q3 Sale - Units (equally divided by 3 - if show monthly) LY Q4 Sale - Units (equally divided by 3 - if show monthly) LY Sales Price Budgeted Sales Price Increase for next year Organization Sales Growth Target (in Units) Product Allowance (% of Sales Revenue) Beginning Inventory for Next Year (Units) LY Average Cost per Inventory Budgeted Increase in Average Cost per Inventory next year Desired Ending Inventory (% of Sales Unit) SG&A Expenses $ $ 3,720 5,450 4,040 6,750 325.00 2.50% 5.00% 1.50% 850 200.00 3.25% 15.00% SG&A Expenses # of Non-Sales FT Employees (FTE) Average Non-Sales FTE Cost/year Incremental Non-Sales FTE hire to support growth New FTE to start Q1 (Jan) New FTE to start Q3 (July) # of Sales FT Employees (FTE) Sales Commission for Sales FTE (% of Gross Sales Revenu # of Stores & Offices Average Monthly Rent per office Variable Marketing Expense (per unit sold) Fixed Monthly Marketing Expense $ es $ $ $ Fixed Monthly IT Expenses $ Monthly Supplies Expenses (per FTE)- sales and non-sal $ 15 65,000 3 1 2 5 5.50% 3 7,000.00 0.50 2,000 3,500 225 Q2- Debt Paydown Schedule (8 points) After completing the budget for Comfy Bedding Co., you are informed that the company will have to borrow debt to ensure sufficent cash Create a debt repayment schedule based on the provided debt terms (Assuming the debt will start Jan 1st of next year) BONUS PTS - Re-do the Project Income Statement based on the company accepting the debt (Hint - what additional expense will need to be included?) - 2 points Principal Annualized Interest Rate Terms (years) Paid monthly $ 550,000 12.50% 2 Q1- Operating Budget (15 points) You have been asked by your VP of Finance to put together the Operating Budgets and the Projected Income Statement for Comfy Bedding Co, using the information provided You can decide to show the budget either in QUARTERLY or MONTHLY format (Hint - whichever time period you choose, please ensure your number matches with that particular period) BONUS PTS - What is the budget cash outflow for inventory purchase next year? (Assumes 70% of current quarter purchases gets paid SAME quarter, and 30% NEXT quarter) - 3 points Comfy Bedding Co. LY Q1 Sale - Units (equally divided by 3 - if show monthly) LY Q2 Sale - Units (equally divided by 3 - if show monthly) LY Q3 Sale - Units (equally divided by 3 - if show monthly) LY Q4 Sale - Units (equally divided by 3 - if show monthly) LY Sales Price Budgeted Sales Price Increase for next year Organization Sales Growth Target (in Units) Product Allowance (% of Sales Revenue) Beginning Inventory for Next Year (Units) LY Average Cost per Inventory Budgeted Increase in Average Cost per Inventory next year Desired Ending Inventory (% of Sales Unit) SG&A Expenses $ $ 3,720 5,450 4,040 6,750 325.00 2.50% 5.00% 1.50% 850 200.00 3.25% 15.00% SG&A Expenses # of Non-Sales FT Employees (FTE) Average Non-Sales FTE Cost/year Incremental Non-Sales FTE hire to support growth New FTE to start Q1 (Jan) New FTE to start Q3 (July) # of Sales FT Employees (FTE) Sales Commission for Sales FTE (% of Gross Sales Revenu # of Stores & Offices Average Monthly Rent per office Variable Marketing Expense (per unit sold) Fixed Monthly Marketing Expense $ es $ $ $ Fixed Monthly IT Expenses $ Monthly Supplies Expenses (per FTE)- sales and non-sal $ 15 65,000 3 1 2 5 5.50% 3 7,000.00 0.50 2,000 3,500 225 Q2- Debt Paydown Schedule (8 points) After completing the budget for Comfy Bedding Co., you are informed that the company will have to borrow debt to ensure sufficent cash Create a debt repayment schedule based on the provided debt terms (Assuming the debt will start Jan 1st of next year) BONUS PTS - Re-do the Project Income Statement based on the company accepting the debt (Hint - what additional expense will need to be included?) - 2 points Principal Annualized Interest Rate Terms (years) Paid monthly $ 550,000 12.50% 2
Expert Answer:
Answer rating: 100% (QA)
Operating Budget in Quarterly Format Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales Units based on LY ... View the full answer
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these finance questions
-
Rice Products Pty. Ltd. is a local firm that produces two moulded plastic products: kickboards and pool buoys. The products are manufactured in a two step process and each process is treated as a...
-
The Taos Museum of Southwestern Arts and Crafts (TMSAC) presents rotating exhibits of the works of artists and artisans from the Southwestern United States. Historically, the museum has derived its...
-
To save for her newborn son's college education, Lea Wilson will invest $1,000 at the beginning of each year for the next 18 years. The interest rate is 12 percent. What is the future value? 1)...
-
Go to the Motley Fool website (www.fool.com), and under the tab "Guides," click on "Retirement." Describe the information available here for planning for your retirement.
-
A painting process consists of two stages. In the first stage, the paint is applied, and in the second stage, a protective coat is added. Let X be the time spent on the first stage, and let Y be the...
-
The television show Nightline conducted a poll in which viewers were asked whether the United Nations headquarters should be kept in the United States. Viewers could respond to the poll by paying 50...
-
Compute the cash proceeds from bond issues under the following terms. For each case, indicate whether the bonds sold at a premium or discount: a. Spring, Inc., issued $300,000 of 10-year, 8 percent...
-
What type of non-financial information is often used by managers to improve customer satisfaction? Explain.
-
Nesheim Construction Company borrowed $500,000 from Oregon Bank. During the same year, Oregon Bank hired Nesheim to remodel its main branch facility for $200,000. Instead of paying cash for the...
-
A project can be either small or large and involve many or a single person. What characteristics help determine whether a project is a program, project, or task? Complex and multidisciplinary...
-
P5.4. (DC, RFC and NRFC) The following data were taken from the financial statements of Chen Corporation for 2021 taxable year: Gross sales Sales returns Cost of goods sold Operating expenses...
-
For the function y a. Find f'(3) == df dx 2x = f(x) = 2x3 + 10: at x= 3. b. Find a formula for x = f (y). f(y)= == c. Find df-1 dy at y = f(3). (f) '(f(3)) = Submit Question
-
Illustrate and explain the main points of the text. Provide examples, ideas, opinions, and paraphrasing of sections that are important. Provide visual support for the points. Do not simply retell the...
-
Juan is a Filipino resident of CDO, he has savings deposit in BPI-Dvsoria Branch, he also has bank deposits in PNB Tokyo Japan. Can the PH government tax the interest income of Juan from his bank...
-
Which of the following hormones is the most potent inhibitor of endocrine secretions? a. Gastrin b. Secretin c. Ghrelin d. Somatostatin
-
A regular deposit of $100 is made at the beginning of each year for 20 years. Simple interest is calculated at i% per year for the 20 years. At the end of the 20-year period, the total interest in...
-
The Millbridge tax collectors office spent $ 32,000 in the first quarter of the year, during which they processed 8,000 tax bills. It took a total of 1,000 hours of clerical time to process the tax...
-
Why is the relevant range the key to the difference between variable and marginal costs?
-
Draft a quarterly cash budget for the Zoo Extravaganza (ZE) for the first two quarters of the coming year. Use just the information in this problem. 1. Interest is paid on the last day of the year...
-
What is the activity in \(\mathrm{Bq}\) and in \(\mathrm{Ci}\) of a \(2.0 \mathrm{mg}\) sample of \({ }^{3} \mathrm{H}\) ?
-
The activity of a sample of the cesium isotope \({ }^{137} \mathrm{Cs}\) is \(2.0 \times 10^{8} \mathrm{~Bq}\). Many years later, after the sample has fully decayed, how many beta particles will have...
-
About \(12 \%\) of your body mass is carbon; some of this is radioactive \({ }^{14} \mathrm{C}\), a beta-emitter. If you absorb \(100 \%\) of the\(49 \mathrm{keV}\) energy of each \({ }^{14}...
Study smarter with the SolutionInn App