Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events

Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events

Accounting

Roletter Company makes and sells artistic frames for pictures of weddings, graduations, and other special events. Bob Anderson, the controller, is responsible for preparing Roletter's master budget and has accumulated the following information for 2021: July 10,000 Estimated sales in units Selling price per unit Direct manufacturing labor hours per unit wage per direct manufacturing labor-hour Number of D.M parts needed to produce one unit Cost of D.M per part January 10,000 54 2 12 2 5 February 14,000 50.5 2 12 2 5 March 7,000 50.5 1.5 12 2 5 Expected information for 2021 April May 8,000 8,000 50.5 50.5 1.5 1.5 13 13 2 2 5 5 5 June 8,000 50.5 1.5 13 2 5 1,000 800 800 8 8 15,000 8,000 1,400 700 800 20% of next month expected units sold 6 6 6 15,000 15,000 20,000 8,000 8,000 8,000 6 20,000 8,000 6 20,000 8,000 the allocation base for manu. Overhead is units produced Desired ending inventory of direct material parts Desired ending inventory of finished goods units Vriable Manu. Overhead per unit Fixed manufacturing overhead Selling and administrative expense Depreciation on manufacturing equipment (included in fixed manu. Overhead cost) Depreciation on office equipment (included in S & A exp) purchase of manu. Equipment that has a useful life of 6 Iyears and no residual value 5,000 5,000 5,000 10,000 10,000 10,000 1,000 1,000 1,000 1,000 1,000 1,000 30,000 You know the following information for the month of dec. 2020 Sales revenue D.M purchases 500,000 50,000 Cash D.M inventory (units) equipment (net) F.G inventory (units) 400 Retained earnings S.C.O You know the following information on Dec.31.2020 10,000 1,200 318,460 80,000 207,023 The company expected that it will collect 90% of each month revenue in cash and the rest will be collected in the next month. The company also had a policy of paying all costs in cash as incurred exept direct material in which it pays only 40% of each month purchases in cash and the rest is paid in the next month Required : Prepare the budgeted balance sheet for the semi-annual period ending in June 30.2021

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Budgeted report for the semi annual upto 30-06-2021

Particular Jan Feb March April May June July
Sale Units (i) 10000 14000 7000 8000 8000 8000  
Sale Rs per unit (ii) 54 50.5 50.5 50.5 50.5 50.5  
Sale Value (i*ii)= iii 540000 707000 353500 404000 404000 404000  
Cash Relised              
90% each month of sale (iii*90%) = iv 486000 636300 318150 363600 363600 363600  
10% following month of sale (iii*10%)=v 50000 54000 70700 35350 40400 40400 40400
opening cash 10000 239000 546300 711650 876600 1046600  
Total Cash (a) 546000 929300 935150 1110600 1280600 1450600  
Expnses Deatils              
Direct labour 20000 28000 10500 12000 12000 12000  
Wages 120000 168000 84000 104000 104000 104000  
Dm Part 20000 28000 14000 16000 16000 16000  
DM cost (material purchased              
40% paid in the same month 20000 28000 14000 16000 16000 16000  
60% paid in the following month 30000 30000 42000 21000 24000 24000 24000
Vaiable overhead 80000 84000 42000 48000 48000 48000  
fixed overhead (less depreciation) 10000 10000 10000 10000 10000 10000  
Selling overhead (less depreciation) 7000 7000 7000 7000 7000 7000  
Total Expenses (b) 307000 383000 223500 234000 234000 234000  
Net (a-b) = c 239000 546300 711650 876600 1046600 1216600  

Note - It is assumed as per the question details it is required the information of cash budget for semi annual therefore non cash item like depreciation are deducted from the fixed overhead and selling overhead becuase depreciation in non cash item therefore it is not included in the expeses paying list.

Related Questions