Prepare the cash payments budget for direct materials purchases for the months of January, February, and March, as well as a summary for the first quarter. Birdfeeders Unlimited makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores.     $15 Sales price per birdfeeder               1.5 Board feet of wood required for each birdfeeder           $4 Cost per board foot (actual)               10% Desired ending wood inventory stated as a percentage of next month’s production requirements     20% Desired ending finished goods inventory (finished birdfeeders) stated as a percentage of next month’s sales                           $550,000 Total cost of direct materials purchases in December           45%  of direct materials purchases are paid in the month of purchase       55% of direct materials purchases are paid in the month after purchase

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter16: Working Capital Policy And Short-term Financing
Section: Chapter Questions
Problem 12P
icon
Related questions
icon
Concept explainers
Question
100%

Prepare the cash payments budget for direct materials purchases for the months of January, February, and March, as well as a summary for the first quarter.

Birdfeeders Unlimited makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores.
    $15 Sales price per birdfeeder          
    1.5 Board feet of wood required for each birdfeeder      
    $4 Cost per board foot (actual)          
    10% Desired ending wood inventory stated as a percentage of next month’s production requirements
    20% Desired ending finished goods inventory (finished birdfeeders) stated as a percentage of next month’s sales
                     
    $550,000 Total cost of direct materials purchases in December      
    45%  of direct materials purchases are paid in the month of purchase  
    55% of direct materials purchases are paid in the month after purchase  
Units
October actual sales (prior year)
November actual sales (prior year)
December actual sales (prior year)
January projected sales
92,000
85,000
78,000
80,000
February projected sales
90,000
March projected sales
95,000
April projected sales
105,000
20% of the total sales are cash sales
80% of the total sales are credit sales
The company's collection history indicates that:
80% of credit sales is collected in the month after the sale
10% is collected two months after the sale
6% is collected three months after the sale
4% is never collected
Transcribed Image Text:Units October actual sales (prior year) November actual sales (prior year) December actual sales (prior year) January projected sales 92,000 85,000 78,000 80,000 February projected sales 90,000 March projected sales 95,000 April projected sales 105,000 20% of the total sales are cash sales 80% of the total sales are credit sales The company's collection history indicates that: 80% of credit sales is collected in the month after the sale 10% is collected two months after the sale 6% is collected three months after the sale 4% is never collected
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT