Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Requirement: Using the data given above, prepare the following budgets along with other supportive schedules for the quarter (April- May June) of the year 2021.

image text in transcribed

Requirement: Using the data given above, prepare the following budgets along with other supportive schedules for the quarter (April- May June) of the year 2021.

1- Sales Budget

2- Production Budget .

3-Cash budget

4-Cash collection schedule

5-Cash payment schedule

6-Variable Manufacturing cost schedule

Jun Alaa Almansour is the owner and manager of Inch artisan studio which manufactures unique home products. They sell and ship their unique home accessories to all Saudi cities. Inch artisan studio is currently reviewing their production data for a new product called (MERAKI) for 2021 Ramadan season. The management of Inch artisan studio needs your help to prepare a budgeted figure for this new product. The owner of Inch artisan studio has provided the following data: Budgeted sales for the next five months are as follows: Feb Mar Apr May Jul 5 10 20 10 5 6 Unit selling price SR 520 Inch needs the finished closing stock equals to 5 + 15% of the following month's budgeted sales in units. A sheet of acrylic can make 10 MERAKI, each sheet of acrylic costs SR 250. Inch would like the raw materials closing stock equals to 1 sheet, and at the end of Feb Inch has 2 sheets of acrylic. 2 labor hours are required for each unit produced, each hour costs SR 60 and will be paid as incurred. Unit variable manufacturing overhead is SR 10 per unit, and fixed manufacturing overhead cost is SR 300 per month will be paid as incurred. 70% of sales are for cash. 30% are on credit and customers pay half of their debt in the month following sale and the balance one month after that. The sheet of acrylic is paid for one month after purchase. . The closing balances at the end of March is SR 20,000. Inch pays a cash dividend of SR 4,000 in May

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Method And Meaning Teachers Guide

Authors: R.M.S. Wilson

2nd Edition

0412436205, 978-0412436208

More Books

Students also viewed these Accounting questions