Princess Cherry Pie Santos

 JMJ MARIST BROTHERS NOTRE DAME OF MARBEL UNIVERSITY GRADUATE SCHOOL Master in Business Administration (MBA) Program A Managerial Accounting Analysis On DASHBOARD - KORONADAL As Partial Fulfillment of the Requirements in BA257 (Managerial Accounting) Reymund Paul F. Blanco, CPA, MBA Professor Princess Cherry Pie E. Santos MBA – 1 TABLE OF CONTENTS INTRODUCTION DASHBOARD Koronadal is a T- shirt printing shop located at Guanzon Blk. 2, Brgy. Morales, Koronadal City, South Cotabato. It is managed by Mr. Deo Moso, one of the owners of Dash Board. But they are engaging to bidding with different projects of various government agencies. Recently, they got the chance to print 2,000,000 copies of an Enumeration Form for DSWD Region XII. Raw Materials Beginning--------------------------------------795,000 Less: Raw Materials Ending----------------------------------118,000 Raw Materials Used--------------------------------------------677,000 Direct Labor-------------------------------------------------------27,990 Manufacturing Overhead--------------------------------------211,275 Total Manufacturing Cost--------------------------------------916, 265 Add: Working Process Beginning----------------------------0 Less: Work in Process Ending--------------------------------0 Cost of Goods Manufactured---------------------------------916, 265 Finished Goods Inventory-------------------------------------2,000,000 Add: Cost of Goods Manufactured--------------------------916, 265 Goods Available for Sale---------------------------------------1,083,735 Less: Finished Goods Inventory Ending--------------------0 Cost of Goods Sold-----------------------------------------------916,265 Sales-------------------------------------------------------------------2,000,000 Cost of Goods Sold------------------------------------------------916,265 Gross Margin--------------------------------------------------------1,083,735 Less: Expenses Income Tax-------------------------------------------------200,000 Fixed Production------------------------------------------10,000 Fixed Depreciation----------------------------------------211,339 Net Income----------------------------------------------------------872,396 CONTRIBUTION APPROACH Sales--------------------------------------------------------------------2,000,000 Less: Variable Cost--------------------------------------------------0 Variable Production-----------------------------------------888,275 Contribution Margin--------------------------------------------------------------------------------1,111,725 Less: Expenses Fixed Administrative Salary-------------------------------27,990 Income Tax----------------------------------------------------200,000 Fixed Production---------------------------------------------10,000239,329 Net Operating Income------------------------------------------------------------------------------872,96 DIRECT MATERIALS Bond Paper- 5,000 Reams @ 150/ ream Ink - Black 10 Liters 15,000 INDIRECT MATERIALS Colored Ink- 65ML275 + 27=7,425 Printer-,650 x 9=41,850 Laptop-18,000 x 9=162,000 LABOR-311X3=933/day=27,990 FIXED COST Office Rent-5,000 Utilities-5,000 Depreciation Expense (Equipment)-1,339 Tax-200,000 Printer= 41,850 - 22,500 2 years =9,675/ 24 Months =403 Laptop= 162,000-117,000 2 =22,500/ 24 Months =936 Raw Materials-795,000 Direct Labor-27,990 Manufacturing Overhead-211,275 Bond Paper Used-4,250 X 500=2,125,000 =117,000 Ink-1,000=1,000 Overhead Applied118,000 DASHBOARD MATERIALS REQUISITION FORM DASHBOARD MATERIALS REQUISITION FORM     Reg. No AB - 0001 Date 3/12/2020 Job # A - 01   Department 1 Printing       Description Quantity Unit Cost Total Cost Laptop Acer-,000 Bond Paper A- Printer-         TOTAL     983,850         Authorized Signature Deo Moso       Owner   DASHBORD EMPLOYEE TIME TICKET     TIME TICKET #01 DATE 3/12/2020   EMPLOYEE: 1 STATION 1       STARTING TIME ENDING TIME HOURS COMPLETED HOURLY RATE AMOUNT JOB # 8:00 5:- A-01 8:00 5:-   8:00 5:-                           TOTAL  - A-01         Authorized Signature DEO MOSO     SUPERVISOR         DASHBORD COAST SHEET JOB # A-01 DATE INITIATE 3/12/2020   DEPARTMENT DATE COMPLETED   ITEM: DSWD REGION 12 UNIT COMPLETED 2,000,00     ENUMERATION FORM       DIRECT MATERIALS DIRECT LABOR MANUFACTURING OVERHEAD REQ. #1 AMOUNT TICKET HOURS AMOUNT HOURS RATE AMOUNT AB-,850 O1 240 27,990.00 -     COST SUMMARY               DIRECT MATERIALS   983,850           DIRECT LABOUR   27,990           MANUFACTURING OVERHEAD   933           TOTAL COST   1,012,773           UNIT COST   .54