Purchase Solution

Preparing Budgets

Not what you're looking for?

Ask Custom Question

Safe and Bright Inc produces outside doors for installation on homes. The following information was gathered to prepare budgets for the upcoming year beginning Jan 1:
Sales force in units...........................................................................5,500 doors
Finished goods inventory Jan 1......................................................... 620 doors
Targe finished good inventory Dec 31............................................... 480 doors
Raw materials inventory-steel Jan 1.................................................. 40,000 pounds
Target inventory-steel Dec 31............................................................ 80,000 pounds
Raw material inventory-glass Jan 1.....................................................6,000 sq feet
Target inventory-glass Dec 31............................................................ 4,000 sq feet
Budgeted purchase price-steel.............................................................$4 per pound
Budgeted purchase price-glass........................................................... $2 per sq foot
The manufacture of each door requires 20 pounds of steel and 6 square feet of glass.

A-prepare the production schedule in units for Safe and Bright.
B-using the production schedule develop the direct materials purchase budgets for steel and glass.
C-why might Safe and Bright target level of steel inventory be higher than last years ending balance and its target level of glass inventory be lower than last years ending balance?

Purchase this Solution

Solution Summary

The solution prepares budgets for the produces outside.

Solution Preview

Please see attachment.

PREPARING BUDGETS
Safe and Bright Inc. produces outside doors for installation on homes. The following information was gathered to prepare budgets for the upcoming year beginning Jan 1:
Sales force in units...........................................................................5,500 doors
Finished goods inventory Jan 1......................................................... 620 doors
Target finished good inventory Dec 31............................................... 480 doors
Raw materials ...

Solution provided by:
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution


Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

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.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.