Question 1 The marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account)     Q1 Q2 Q3 Q4 total  Budgeted units sales  ? 10% increase  10 % decrease  16,335 62,685 Budget selling price per unit  18 18 18 ? 18 budgeted sales revenue  ? 297,000 ? 294,030 ?   Other information                   Each quarter ending finished goods inventory is 20% of next month units sold.       Next year first quarter beginning inventory is 3,000.             Each finished units require 3 grams of raw material that cost Rs 3 per unit.             Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs      Beginning inventory of raw material in first quarter 3,000 grams    FIND UNIT SALES of Q1 Answer format should be like : 10000 donot USE COMMA's or Currency or UNITs. Answer should be plain number

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...
icon
Related questions
icon
Concept explainers
Question

Question 1

The marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account)

 

 

Q1

Q2

Q3

Q4

total 

Budgeted units sales 

?

10% increase 

10 % decrease 

16,335

62,685

Budget selling price per unit 

18

18

18

?

18

budgeted sales revenue 

?

297,000

?

294,030

?

 

Other information                  

  • Each quarter ending finished goods inventory is 20% of next month units sold.      
  • Next year first quarter beginning inventory is 3,000.            
  • Each finished units require 3 grams of raw material that cost Rs 3 per unit.            
  • Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs     

Beginning inventory of raw material in first quarter 3,000 grams 

 

FIND UNIT SALES of Q1

Answer format should be like : 10000 donot USE COMMA's or Currency or UNITs. Answer should be plain number

Expert Solution
steps

Step by step

Solved in 2 steps

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
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College