One of the products that South African Golden Brewers manufactures here in South Africa is the Three Brothers wine. The Three Brothers wine is derived through the manufacturing process, from Cape vineyard grown grapes. However, the wine is manufactured according to set standards in order to ensure that it adheres to the Total Quality Management (TQM) measures that the company adheres to. The standards are as follows: (To create One Unit [bottle of wine]) Input Direct materials STANDARD COST CARD Standard quantity Standard price or or hours rate Standard cost per unit 16 1,5 24 Direct labour 2 6 12 Variable overheads 3 5 15 Allocated fixed 2 10 manufacturing overheads (hrs) Total standard unit cost Budgeted Production Units (Bottles) 10 000 Actual Units (Bottles) Produced: 9 000 Budgeted Fixed Manufacturing Overheads 100 000 Actual Costs are as follows: 61 Quantity Total Cost Unit Cost Direct Materials (grapes) Direct Labour 50 000 40 000 Variable Manufacturing Overheads: 25 000 Fixed Manufacturing Overheads (actual) 100 000 300 000 112 500 255 000 2 7,5 4,5 Required: Build a standard costing model using "Excel" that will enable South African Golden Brewers to automate their standard costing process for Three Brothers Wine. The model should include a standard cost card and all relevant variances that will pull through to the variance report.