Homework Help is Here – Start Your Trial Now!
Business
Accounting
Webster provides the following information regarding its actual and future sales: January Actual February Actual 50,000 $ 80,000 $ May Forecast 90,000 S 100,000 $ 120,000 40,000 $ 60,000 March April Forecast Forecast Cash Sales Credit Sales $ 80,000 $ 12,000 $ 90,000 $ Management expects that 40% of credit sales are collected in the month of the sale. 40% are collected in the month after the month of sale. 20% are collected in the month following. na memo to your team (who are preparing the budgets), management also provides the following information: - The company has an obligation to repay $120,000 in debt in April. There is no debt to be repayed in the other months - Cost of sales is 50% of sales revenue. - The company has regular deliveries of inventory to ensure that it can continue to meet its customer obligations. Inventory deliveries are paid in the following month and expected to be equal to 60% of sales in the delivery month. - Salaries and wage expenses add up to $10,000 per month. A further 20% is added for a variety of on costs. These amounts are paid in the same month. - Utilities costs are $3,000, $3,000, $4,000 and $5,000 in each of February, March, April and May, respectively. These costs are paid in the month following. - On the final day in April, the company commissions a long-term advertising contract for the following 12 months, to be used monthly. The contract is paid upfront on the same day. The contract is worth $48,000 spread equally across the 12 months. - The company has several items of PPE. At the end of April, it purchases another vehicle to $20,000. Depreciation prior to the purchase was $4,000 per month. Following, the purchase of the new vehicle, depreciation is expected to increase to $4,500 per month. - Management expects to pay $1,000 in interest each month.

Webster provides the following information regarding its actual and future sales: January Actual February Actual 50,000 $ 80,000 $ May Forecast 90,000 S 100,000 $ 120,000 40,000 $ 60,000 March April Forecast Forecast Cash Sales Credit Sales $ 80,000 $ 12,000 $ 90,000 $ Management expects that 40% of credit sales are collected in the month of the sale. 40% are collected in the month after the month of sale. 20% are collected in the month following. na memo to your team (who are preparing the budgets), management also provides the following information: - The company has an obligation to repay $120,000 in debt in April. There is no debt to be repayed in the other months - Cost of sales is 50% of sales revenue. - The company has regular deliveries of inventory to ensure that it can continue to meet its customer obligations. Inventory deliveries are paid in the following month and expected to be equal to 60% of sales in the delivery month. - Salaries and wage expenses add up to $10,000 per month. A further 20% is added for a variety of on costs. These amounts are paid in the same month. - Utilities costs are $3,000, $3,000, $4,000 and $5,000 in each of February, March, April and May, respectively. These costs are paid in the month following. - On the final day in April, the company commissions a long-term advertising contract for the following 12 months, to be used monthly. The contract is paid upfront on the same day. The contract is worth $48,000 spread equally across the 12 months. - The company has several items of PPE. At the end of April, it purchases another vehicle to $20,000. Depreciation prior to the purchase was $4,000 per month. Following, the purchase of the new vehicle, depreciation is expected to increase to $4,500 per month. - Management expects to pay $1,000 in interest each month.

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
Webster provides the following information regarding its actual and future sales: February March April January Actual May Actual Forecast Forecast Forecast Cash Sales $ 50,000 $ 80,000 $ 90,000 $ 100,000 $ 120,000 Credit Sales 80,000 $ 12,000 $ 90,000 $ 40,000 $ 60,000 Management expects that 40% of credit sales are collected in the month of the sale. 40% are collected in the month after the month of sale. 20% are collected in the month following. na memo to your team (who are preparing the budgets), management also provides the following information: - The company has an obligation to repay $120,000 in debt in April. There is no debt to be repayed in the other months - Cost of sales is 50% of sales revenue. - The company has regular deliveries of inventory to ensure that it can continue to meet its customer obligations. Inventory deliveries are paid in the following month and expected to be equal to 60% of sales in the delivery month. - Salaries and wage expenses add up to $10,000 per month. A further 20% is added for a variety of on costs. These amounts are paid in the same month. - Utilities costs are $3,000, $3,000, $4,000 and $5,000 in each of February, March, April and May, respectively. These costs are paid in the month following. - On the final day in April, the company commissions a long-term advertising contract for the following 12 months, to be used monthly. The contract is paid upfront on the same day. The contract is worth $48,000 spread equally across the 12 months. - The company has several items of PPE. At the end of April, it purchases another vehicle to $20,000. Depreciation prior to the purchase was $4,000 per month. Following, the purchase of the new vehicle, depreciation is expected to increase to $4,500 per month. - Management expects to pay $1,000 in interest each month. - The tax rate is 30%. Company income tax is then paid later in the year, but a provision is made during the month that profit is made.
Transcribed Image Text:Webster provides the following information regarding its actual and future sales: February March April January Actual May Actual Forecast Forecast Forecast Cash Sales $ 50,000 $ 80,000 $ 90,000 $ 100,000 $ 120,000 Credit Sales 80,000 $ 12,000 $ 90,000 $ 40,000 $ 60,000 Management expects that 40% of credit sales are collected in the month of the sale. 40% are collected in the month after the month of sale. 20% are collected in the month following. na memo to your team (who are preparing the budgets), management also provides the following information: - The company has an obligation to repay $120,000 in debt in April. There is no debt to be repayed in the other months - Cost of sales is 50% of sales revenue. - The company has regular deliveries of inventory to ensure that it can continue to meet its customer obligations. Inventory deliveries are paid in the following month and expected to be equal to 60% of sales in the delivery month. - Salaries and wage expenses add up to $10,000 per month. A further 20% is added for a variety of on costs. These amounts are paid in the same month. - Utilities costs are $3,000, $3,000, $4,000 and $5,000 in each of February, March, April and May, respectively. These costs are paid in the month following. - On the final day in April, the company commissions a long-term advertising contract for the following 12 months, to be used monthly. The contract is paid upfront on the same day. The contract is worth $48,000 spread equally across the 12 months. - The company has several items of PPE. At the end of April, it purchases another vehicle to $20,000. Depreciation prior to the purchase was $4,000 per month. Following, the purchase of the new vehicle, depreciation is expected to increase to $4,500 per month. - Management expects to pay $1,000 in interest each month. - The tax rate is 30%. Company income tax is then paid later in the year, but a provision is made during the month that profit is made.
Using the following table and the information presented above, compute the Summary of Cash Flowsfor Webster Pty Ltd for March to May. The table includes items that may not have to be included in a summary of cash flows. You should leave these items blank. Cash outflows should be listed as negative values. March April May Forecast Forecast Forecast Receipts from Customers (3 items) Less Cash Outflows Cost of goods sold Inventory Purchases Salaries and wages paid (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) Utilities Depreciation expense Acquisition of vehicle Advertising Interest expense Debt repayment Income Tax Total cash outflows $ $ $ Change in cash (3 items) Cash at Start 5,000 5,000 5,000 Cash at End 5,000 5,000 5,000
Transcribed Image Text:Using the following table and the information presented above, compute the Summary of Cash Flowsfor Webster Pty Ltd for March to May. The table includes items that may not have to be included in a summary of cash flows. You should leave these items blank. Cash outflows should be listed as negative values. March April May Forecast Forecast Forecast Receipts from Customers (3 items) Less Cash Outflows Cost of goods sold Inventory Purchases Salaries and wages paid (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) (3 items) Utilities Depreciation expense Acquisition of vehicle Advertising Interest expense Debt repayment Income Tax Total cash outflows $ $ $ Change in cash (3 items) Cash at Start 5,000 5,000 5,000 Cash at End 5,000 5,000 5,000
Expert Solution
steps

Step by step

Solved in 3 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
SEE MORE TEXTBOOKS