Need Help ?

Home / Expert Answers / Other / You are the newly hired Controller for Retro Vinyl. The proprietors of RV hired you due to your vast

You are the newly hired Controller for Retro Vinyl. The proprietors of RV hired you due to your vast ...


You are the newly hired Controller for Retro Vinyl. The proprietors of RV hired you due to your vast experience in the furniture industry, which now spans almost 25 years. Your first task is to create a master budget for the four quarters of the 2023 fiscal year, which begins January 1st and ends December 31st. The master budget must include the following detailed budgets: 1. A sales budget with a schedule of expected cash collections from sales. Show the budget by quarter and in total. 2. A production budget. Show the budget by quarter and in total. 3. A direct material purchase budget with expected cash disbursements for material purchases. Show the budget by quarter and in total. 4. A direct labor budget in dollars. Show the budget by quarter and in total. 5. A manufacturing overhead budget in dollars. Show the budget by quarter and in total. 6. An ending finished goods inventory budget. Show the budget by quarter and in total. 7. A selling, general, and administrative budget. Show the budget by quarter and in total. 8. A cash budget. Show the budget by quarter and in total. 9. A budgeted income statement for the period ending December 31. Use the absorption costing approach. 10.A budgeted balance sheet as of December 31.





We have an Answer from Expert

View Expert Answer

Expert Answer


Creating a master budget for Retro Vinyl involves several detailed components. Below, I’ll outline a framework for each section of the budget based on typical assumptions. Note that actual figures would depend on specific sales forecasts, cost structures, and operational plans for Retro Vinyl.

1. Sales Budget and Cash Collections

Assume projected sales for the year are as follows:

  • Q1: $100,000
  • Q2: $150,000
  • Q3: $200,000
  • Q4: $250,000
  • Total Sales: $700,000

Expected Cash Collections: Assume cash is collected 70% in the quarter of sale and 30% in the following quarter.

Quarter

Sales

Cash Collections

Q1

100,000

70,000

Q2

150,000

105,000

Q3

200,000

140,000

Q4

250,000

175,000

Total

700,000

490,000

 

2. Production Budget

Assuming a desired ending inventory of 20% of the next quarter's sales:

We have an Answer from Expert

Buy This Answer $10

Radioactive Tutors

Radio Active Tutors is a freelance academic writing assistance company. We provide our assistance to the numerous clients looking for a professional writing service.

NEED A CUSTOMIZE PAPER ON THE ABOVE DETAILS?
Order Now


OR

Get outline(Guide) for this assignment at only $10

Get Outline $10

**Outline takes 30 min - 2 hrs depending on the complexity and size of the task
Designed and developed by Brian Mubichi (mubix)
WhatsApp