Purchase Solution

Dynamic Futon: Forecast level of payable for each month

Not what you're looking for?

Ask Custom Question

Dynamic Futon forecasts the following purchases from suppliers:

Jan. Feb. Mar. Apr. May Jun.
Value of goods ($ millions) 32 28 25 22 20 20

a. Forty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $22 million, what is the forecasted level of payables for each month?

b. Suppose that from the start of the year the company stretches payables by paying 40% after one month and 20% after two months. (The remainder continue to be paid cash on delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment.

Purchase this Solution
Solution Summary

The solution computes forecast level of payable for each month.

Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Motivation

This tests some key elements of major motivation theories.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • Accounting: Working capital management and Ratios

    Forty percent of goods are supplied cash- on- delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $ 22 million, what is the forecasted level of payables for each month? b.

  • Assuming the amount budgeted to be produced in January is 30

    The labor capacity for a normal eight-hour shift for a month is 50,000 direct labor hours each for both Departments A and B. Overtime is paid at time and a half.

  • Recording business transactions/ forecasting

    Here is a forecast of sales by National Bromide for the first 4 months of 2004 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 15 24 18 14 Sales on credit 100 120 90 70 On average, 50 percent of credit sales are paid for

  • Preparing a cash flow forecast given journal entries

    Required: Prepare a Cash Flow Forecast for KK for the month of January 2013. Include appropriate supporting schedules. KK Products Ltd.

  • Cash budget

    Prepare a cash budget for the month of January and February. Please see the attachment. The solution explains how to prepare a cash budget

  • Master Budgeting for Example Companies

    It believes that unit sales will increase at a rate of 10% each month for the next three months (beginning with April) if the selling price is reduced to $320 per unit and advertising expenses are increased by 25% and remain at that level for all three

  • Preparing forecasted financial statements

    A dynamic Excel sheet shows how to prepare forecasted financial statements using the percentage of Sales Method.

  • T-Accounts and financial statements

    You negotiate a line of credit with the bank for up to $250,000 with an annual interest rate of 7%. Interest is payable on the first day of each month for the interest incurred during the previous month.

  • Balance Sheet and Forecasting Calculations

    Accounts payable are expected to increase from their current level of 10 million to a new level of 13 million next year.

View More Related Solutions